Stored Procedure Properties (General Page)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)

Displays information about a stored procedure. All information is read-only.

Options

Database
The name of the database containing this stored procedure.

Server
The name of the current server instance.

User
The name of the user of this connection.

Created date
Displays the date the stored procedure was created.

Name
The name of the current stored procedure.

Schema
Displays the schema that owns the stored procedure.

System object
Indicates whether the stored procedure 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 stored procedure is encrypted. Values are True and False.

For replication
Indicates if the object was created with the FOR REPLICATION option.

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

Recompile
Indicates if the object was created with the RECOMPILE option.