>I've been using sysobjects and syscomments in SQL 2000 to get base table information on our views. I seem to dimly recall that in SQL 2005 this is discouraged in favor of using a system view or information_schema.???? or a sp_something or other. Does anyone have any info on this? Thanks.
Hi Gary,
In SQL 2005 info about views stored the following catalog views: sys.views, sys.columns, sys.sql_dependencies and sys.sql_modules. The last one stores the text of the CREATE VIEW statement.
--sb--