Printing or saving SQL Server 7.0 schema to a file

[originalcool]

How can I pipe the SQL Server database structure to a file (i.e. MS Word doc)? Short of linking the SQL Server tables to an Access database and using the Documenter tool, is there a better way to print table structures?

 

[Andel]

Yes, by generating script. Right click the table, highlight "all tasks" then click on "generate sql script".





Andel
andelbarroga@hotmail.com

http://andyb.8m.com

 

[tlbroadbent]

You may want to examine the INFORMATION_SCHEMA views that exist in each database. For example; the view INFORMATION_SCHEMA.Columns lists all of the columns in each table and view in the current database.

Using the INFORMATION_SCHEMA views, you can create tabular reports of your schemas.

1- Select which columns of the view you wish to see on your report.
2- Create and run a query in Query Analyzer.
3- Copy and paste the results into Word. Or you can save the result and import into Excel or some other program. Terry

http://members.home.net/tlbroadbent/index.htm