Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

?: How do I print Table Properties

Apr 29, 2002, 2:02 PM
tuck007
New User (2 posts)
Apr 29, 2002, 2:02 PM
Post #1 of 3
Views: 12690
Shortcut
Quote Reply
?: How do I print Table Properties
I have been asked to print out the schema of our database tables. I wanted to know how to, using SQL Enterprise manager with MS SQL 2000, print out the column names, sizes, type, etc... for all the tables.

.:TUCK:.
.:TUCK:.
Apr 29, 2002, 3:27 PM
Alex
Administrator (9387 posts)
Apr 29, 2002, 3:27 PM
Post #2 of 3
Views: 12162
Shortcut
Quote Reply
Re: [tuck007] ?: How do I print Table Properties In reply to
Use:

sp_help tablename

Cheers,

Alex
--
Gossamer Threads Inc.
May 3, 2002, 12:25 PM
tuck007
New User (2 posts)
May 3, 2002, 12:25 PM
Post #3 of 3
Views: 12167
Shortcut
Quote Reply
Re: [Alex] ?: How do I print Table Properties In reply to
That was not exactly what I was hoping to do. Someone clued me into this method:

Code:
Select *
From Information_schema.columns
Where (table_name='tablename')
This gave me a lot of info in the query return. I have more than 70 tables in a database, how can I print all that information out about each tale quickly and easily. Presently, I'm trying to copy and paste into an Excel sheet and then move onto the next table. Any suggestions?
.:TUCK:.