RSS

Daily Archives: June 27, 2012

View is not showing newly added column in table

Hi all,
This is for the people who still use “Select * From Table” in their SQL Views. I don’t know what is the reason that you are using this way to create your views, but you could be the victim of this scenario (see… what title says).

Let me show you how you can solve this issue… in-case you come across one.

When this happens??
You make changes in table which is the source of your view. Changes like modifying existing column definition, adding new columns or removing existing columns from table could cause this issue.

Where can I see this issue??
Check the meta-data of your table and view for comparison. (Tip: You can either use traditional method using SYS.OBJECTS joins SYS.COLUMNS or you can check using INFORMATION_SCHEMA.COLUMNS)

What is the solution?
There are different ways to circumvent this issue.

Read the rest of this entry »

 

Tags: , , , , ,