I can list all views in SQL Server 2008 by using 'SELECT * FROM sys.views'
What I want to do is list only the views that are schema bound. How can I do this?
+3
A:
SELECT * FROM sys.views WHERE OBJECTPROPERTY(object_id, 'IsSchemaBound')=1
Remus Rusanu
2010-01-12 16:34:14
+1 another marvellous gem revealed by RR :-) Thanks!
marc_s
2010-01-12 16:56:25
This is great, I'm curious now if there is a similar way to look for schema bound functions as well.
jpierson
2010-08-18 16:15:01
@jpierson: replace `sys.views` with `sys.objects` and add `AND type = 'FN'`.
Remus Rusanu
2010-08-18 17:10:03