Post reply

How do I print the design of a table??

  • September 11, 2007 at 12:40 pm

    #177461

    I recently migrated a database from Access 2000 to SQL Server using SSMA.  Now I have the task ahead of me to go through the design of each table to ensure that the types and lengths are consistent and applicable. (This was NOT done to the Access tables).

    My question is simple:  How do I print out the table design???  I have no issues viewing them in SSMSE but I can't seem to print them out.  Is there code that I need to write or is there an option that I missed on the toolbar.

    Thanks!!

  • September 12, 2007 at 9:27 am

    #733162

    How about a subset of the following?

    select * from INFORMATION_SCHEMA.COLUMNS

  • September 12, 2007 at 9:48 am

    #733171

    That's exactly what I was looking for!  Thanks, Carlos

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

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