View Definition of Stored Procedure in Query Editor

In this blog I will show you how to 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.