Database Structure 1

[dddenney]

I need to print out the table structures of all the user tables of a particular database for documentation purposes. Is there any stored procedure or tool that will allow me to do this?

 

[gradley]

This is what Microsoft recommends you use:

select * from information_schema.columns
order by table_name, ordinal_position


exec sp_help <table Name>, will also give you information about each table.

 

[dddenney]

Thanks gradley! Exactly what I needed.

 

[dddenney]

Any way to print out a list of all the stored procedures (and there parameters if possible)? I'm taking over for someone who didn't leave any documentation.

 

[gradley]

select * from INFORMATION_SCHEMA.ROUTINES

Take a look at Books On Line for all the INFORMATION_SCHEMA views and the various "exec sp_help..." procedures. There is alot of metadata information you can get at with these commands.

 

[dddenney]

Thanks again gradley. This will be a huge help. I'll make sure to read up on the Information_Schema info.

Thanks!