According to the BOL, the Information_Schema.View_Table_Usage "Contains one row for each table, in the current database, used in a view" . Let us see how to use it to find out the views on a given table:
SELECT VIEW_NAME FROM information_schema.view_table_usage
WHERE table_name = 'Categories'
returns you the view names on the table Categories.
Note: information schema view returns information about the objects to which the current user has permissions.
Did you like this post?
|subscribe via rss||subscribe via e-mail|
|print this post||follow me on twitter|