System Settings MSSQL Tutorial

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