View Definition of Stored Procedure in Query Editor

Syntax

USE DatabaseName;
GO
EXEC sp_helptextN'StoredProcedureName';


Modify the preceding SQL Syntax with appropriate database name and stored procedure name and execute the SQL Syntax.

EXEC sp_helptextN'GetDetails';



So we got the stored procedure definition by running the query. I hope this trick is useful to beginners.

Ebook Download
View all
Learn
View all