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.

X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now