Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export tables (description and fields) 1

Status
Not open for further replies.

Zen216

MIS
Jul 13, 2006
616
US
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.
 
SELECT * FROM INFORMATION_SCHEMA.COLUMNS is a good place to start.
 
Visio Proffesional will allow you to reverse engineer you db.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck
 
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.
 
did you get all links too, i mean F.keys, P.keys, from which table to which.?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top