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>)
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>)
