• Article

User-Defined Function Properties (General Page)

Displays information about a user-defined function. All information is read-only.

Options

  • Database
    The name of the database containing this function.

  • Server
    The name of the current server instance.

  • User
    The name of the user of this connection.

  • Created date
    Displays the date the function was created.

  • Name
    The name of the current function.

  • Schema
    Displays the schema that owns the function.

  • System object
    Indicates whether the function is a system object. Values are True and False.

  • ANSI NULLs
    Indicates if the object was created with the ANSI NULLs option.

  • Encrypted
    Indicates whether the function is encrypted. Values are True and False.

  • Function type
    Indicates if the function is a multistatement table-valued function, an inline table-valued function, or a scalar function.

  • Quoted identifier
    Indicates if the object was created with the quoted identifier option.

  • Schema bound
    Indicates whether the function is schema-bound. Values are True and False. For information about schema-bound function, see the SCHEMABINDING portion of CREATE FUNCTION (Transact-SQL).