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

  • Article

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.