Search code examples
sql-serverview

How do I query schema bound views?


I can list all views in SQL Server 2008 by using

SELECT * FROM sys.views

What I want to do is to list only the views that are schema bound. How can I do this?


Solution

  • SELECT * 
    FROM sys.views 
    WHERE OBJECTPROPERTY(object_id, 'IsSchemaBound') = 1