16 January 2014

Get the related views to a table

SELECT view_name, Table_Name
FROM
 INFORMATION_SCHEMA.VIEW_TABLE_USAGE
WHERE
 Table_Name= 'YourTableName'
ORDER
 BY view_name, table_name

No comments:

Post a Comment