Export tables (description and fields) 1

[Zen216]

Hello,
We have had a request to document all of the tables, usage, and their functions...

Is there an easy way to do this? I tried the diagram, it gives me the table names and the column names,,, but I cannot export it,,,
And since there is so many tables, manually typing them into excel is going to be a nightmare....

I do not need the data in the tables,, I just need the table names, and the column names in each table, and if there is a way to export that right into an excel file,, that would be great...
Is it possible?

Thanks everyone..

SQL server 2000 std, running on Windows server 2003.

 

[RiverGuy]

SELECT * FROM INFORMATION_SCHEMA.COLUMNS is a good place to start.

 

[MDXer]

Visio Proffesional will allow you to reverse engineer you db.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[Zen216]

thanks guys..
I just needed the table and column names so I used

SELECT table_name, column_name
FROM INFORMATION_SCHEMA.COLUMNS
ORDER BY table_name

then I just copied and pasted into an excel sheet. IT saved me a ton of time..
Thanks again.

 

[roseusa]

did you get all links too, i mean F.keys, P.keys, from which table to which.?