Pages

Thursday, December 24, 2009

sp_help or describe a table structure

Describe temporary table:
tempdb..sp_help #monitor

Describe permenant table
sp_help db_jobs


Some of the stored procs are quite long and all of the code is not contained in the syscomments text column. The sp_helptext proc returns all the lines for a stored proc no matter how long it might be.
EXEC sp_helptext 'dbo.proc1';

No comments:

Post a Comment