Mega Code Archive

 

Categories / MSSQL Tutorial / System Settings

 

Returning Information about User-Defined Functions

Syntax  for the OBJECTPROPERTY() Function OBJECTPROPERTY ( <object_id> , <property> ) IsScalarFunction IsInlineFunction IsTableFunction IsDeterministic IsSchemaBound SELECT   OBJECTPROPERTY(OBJECT_ID('dbo.fibonacci'), 'IsScalarFunction')