Mega Code Archive

 

Categories / MSSQL Tutorial / System Settings

 

Using the OBJECTPROPERTY Function to Check Whether a View is Indexable

SELECT OBJECTPROPERTY(OBJECT_ID('view_name'), 'IsIndexable')