New to SQL Server

  • What is the easiest way to get a description of a table w/o all of the junk.  EG:  just want column_name, type_name, precision, length, is_nullable.  And I need to print this.  Right now I am using sp_help and then copying to another file, changing the file to be what I want and printing it.  Too much time.  Any help would be great!

     

  • You should check in script already posted in this site. There are many and some of them are very good.

  • Use the diagrammer in SQL Server. Pick your tables and do a custom view of the items. This will give you a nice view of the table and you can get a lot of details the way you want for printing.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply