I blog whenever i find things to remember and which are interesting when i am working/learning. I am happy if these experiences are useful to someone else too :) . Please feel free to suggest/correct. These are just out of my experiences . So they may be always a better way to do them !
I view life as a continuous learning experience !!
Wednesday, November 3, 2010
List of all the Views from Database in SQL Server
SELECT SCHEMA_NAME(schema_id) AS schema_name
,name AS view_name
,OBJECTPROPERTYEX(OBJECT_ID,'IsIndexed') AS IsIndexed
,OBJECTPROPERTYEX(OBJECT_ID,'IsIndexable') AS IsIndexable
--,*
FROM sys.views;
No comments:
Post a Comment