Export (0) Print
Expand All

User-Defined Function Properties (General Page)

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

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

Community Additions

ADD
Show:
© 2014 Microsoft