View Refresh

Database
Highlighted
Enthusiast

View Refresh

I have a table whering i need to be changing one of columns datatype length from 15 characters to 30 characters.

So in that case, is it mandatory to refresh its corresponding view also or need not?

1 REPLY
Teradata Employee

Re: View Refresh

Hi.

 

Views are just 'stored queries'. There is no 'dependency chain'. As long as the columnnames exist in the table, there is no need to re-create the view.

 

Cheers.

 

Carlos.