View Definition of Stored Procedure in Query Editor


USE DatabaseName;
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.