Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

A CommandSchema instance may also contain the following extended properties. These properties will help you determine what kind of function you are consuming.

Extended Property KeySchemaExplorer.ExtendedPropertyName Property NameDescription
CS_IsCLRIsCLRAssembly (CLR) stored-procedure
CS_IsAggregateFunctionIsAggregateFunctionSQL Aggregate aggregate function
CS_IsScalarFunctionIsScalarFunctionSQL scalar function
CS_IsTableValuedFunctionIsTableValuedFunctionSQL table-valued-function
CS_IsInlineTableValuedFunctionIsInlineTableValuedFunctionSQL inline table-valued function
CS_IsMultiStatementTableValuedFunctionIsMultiStatementTableValuedFunctionSQL multi statement table-valued function
Info
You can download a sample templateĀ hereĀ that shows off how to detect and consume functions.

...