Returning Information about User-Defined Functions : OBJECTPROPERTY « System Settings « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Settings
  3. OBJECTPROPERTY
Syntax for the OBJECTPROPERTY() Function
OBJECTPROPERTY ( <object_id> , <property> )
IsScalarFunction
IsInlineFunction
IsTableFunction
IsDeterministic
IsSchemaBound
SELECT
  OBJECTPROPERTY(OBJECT_ID('dbo.fibonacci'), 'IsScalarFunction')








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