Monday, April 7, 2014

SQL Server View does not return a newly added column

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