Freigeben über

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

  • Artikel

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.

Comments

  • Anonymous
    December 15, 2015
    How do I perform the same operation in MySQL?