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