Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » T-SQL   (RSS)
Sorry, but there are no more tags available to filter with.

How to parse the view definition and get the base tables and base columns information

You can use INFORMATION_SCHEMA.VIEW_TABLE_USAGE and INFORMATION_SCHEMA.VIEW_COLUMN_USAGE from SQL70 onwards. And you can use sys.sql_dependencies in SQL Server 2005.
Posted by vishah | 0 Comments
Filed under:
 
Page view tracker