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).