Stored Procedure Properties (General Page)

 

Applies To: SQL Server 2016

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

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.

Stored Procedures (Database Engine)
CREATE PROCEDURE (Transact-SQL)
ALTER PROCEDURE (Transact-SQL)

Community Additions

ADD
Show: