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