SQL 2000 View Problem
-
Hi using SQL 2000 i created a table (let - TA) and its view (sel * from TA) as VA after creating the view, i added one column to TA but the view is not showing it. the view must have to rebuild, in sysColumns it doesn't shown the new col name in view. any easy method there have innorder to rebuild it. Thanks in advance panal
-
Hi using SQL 2000 i created a table (let - TA) and its view (sel * from TA) as VA after creating the view, i added one column to TA but the view is not showing it. the view must have to rebuild, in sysColumns it doesn't shown the new col name in view. any easy method there have innorder to rebuild it. Thanks in advance panal
-
Hi using SQL 2000 i created a table (let - TA) and its view (sel * from TA) as VA after creating the view, i added one column to TA but the view is not showing it. the view must have to rebuild, in sysColumns it doesn't shown the new col name in view. any easy method there have innorder to rebuild it. Thanks in advance panal
panalprasad wrote:
any easy method there have innorder to rebuild it.
Use ALTER VIEW to recreate the view. And, it is considered better practice to actually specify the columns you want to use. Only use SELECT * for quick-to-write ad hoc queries.
Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
If there is a possibilty that the master table changes frequently go for cursors instead of views...
Gautham
gauthee wrote:
If there is a possibilty that the master table changes frequently go for cursors instead of views...
:confused: How would cursors solve the problem?
Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos