Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL database in Microsoft Fabric
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.
See Also
Stored Procedures (Database Engine)
CREATE PROCEDURE (Transact-SQL)
ALTER PROCEDURE (Transact-SQL)