I added a column to a table in a SQL Server DB. A View which does 'Select *' from the table, did NOT return the new column.
Before the change, the definition of the table was -
Column_A Column_B Column_C
I added a new column so the table now has 4 columns -
Column_A Column_B Column_C Column_D
The definition of the view is:
Select * From Table
To get the view to return the new column (Column_D), I had to drop and re-create the view.
No comments:
Post a Comment