Using Transact-SQL To view the definition of a procedure in Query Editor This will display the procedure definition. In Object Explorer, connect to an instance of Database Engine and then expand that instance.Įxpand Databases, expand the database in which the procedure belongs, and then expand Programmability.Įxpand Stored Procedures, right-click the procedure and then select Script Stored Procedure as, and then select one of the following: Create To, Alter To, or Drop and Create To.
To view the definition a procedure in Object Explorer
#To view stored procedure in aqua data studio how to#
How to View the Definition of a Stored Procedure Samples are provided later in this article. Instead, use sys.sql_modules object catalog view. The system stored procedure sp_helptext is not supported in Azure Synapse Analytics. For more information, see Metadata Visibility Configuration. The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. These permissions are implicitly held by members of the db_owner, db_ddladmin, and db_securityadmin fixed database roles. The definition of user objects is visible to the object owner or grantees that have any one of the following permissions: ALTER, CONTROL, TAKE OWNERSHIP, or VIEW DEFINITION. System object definitions are publicly visible. To view the definition of a procedure, using: SQL Server Management Studio, Transact-SQL This article describes how to view the definition of procedure in Object Explorer and by using a system stored procedure, system function, and object catalog view in the Query Editor. Analytics Platform System (PDW) View the definition of a stored procedure
0 kommentar(er)
