Stored procedure question

asram · #1 (**permalink**) 11-11-03, 17:41

How to see the contents of the stored proc!? (like sp_help <stored proc name> in sybase)

sathyaram_s · #2 (**permalink**) 11-11-03, 18:51

You mean the stored procedure text ?

export to procname.del of del
select text from syscat.procedures where procname=<procname>

This command will export the procedure text to the file ...

Remember, only SQL SPs have the Text column populated ...

BTW, if you are on V8, syscat.routines is the view which will have this information

Sathyaram

Quote:

Originally posted by asram
How to see the contents of the stored proc!? (like sp_help <stored proc name> in sybase)