I have this to find the list of all views in a database and when they were created... however, I want to see when a view was modified (specifically when a new column was added/ if new columns were ...
I need to get parent tables of each column in a view in MSSQL 2005. Using C#, VS2005.<BR><BR>Tried:<BR>1) exec sp_helptext(viewname)<BR>2) select * from INFORMATION_SCHEMA.VIEWS where Table = ...