Using the OBJECTPROPERTY Function to Check Whether a View is Indexable : OBJECTPROPERTY « System Settings « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Settings
  3. OBJECTPROPERTY
SELECT OBJECTPROPERTY(OBJECT_ID('view_name'), 'IsIndexable')
26.20.OBJECTPROPERTY
26.20.1.Returning Information about User-Defined Functions
26.20.2.Using the OBJECTPROPERTY Function to Check Whether a View is Indexable
26.20.3.Check with OBJECTPROPERTY function
26.20.4.Use OBJECTPROPERTY and OBJECT_ID to check the table existance