How to find the definition or structure of stored procedures?

Structure or definition of the stored procedure is saved inside the syscomments  table.

Definition of the stored procedure can be obtained by using the following commands:

sp_helptext  <Stored Procedure Name>

Other way to find out the structure of the stored procedure is Using the following query to fetch stored procedure structure:

select text from syscomments where id =(SELECT id from sysobjects where name =<Procedure Name>) 

This entry was posted in . Bookmark the permalink.

Leave a reply