How to print the dictionnary

[sqlSam]

hi,
How can I print the database dictionary ?

I'm using SQL SERVER 7

Thanks

Sam

 

[Bernadette]

Hi Sam

Click on the Tools Menu and Select Database Scripting. Ensure you script all objects. Under the Options tab you can script additional options, ie. contstraints, triggers, indexes.

Hope this helps :->

Bernadette

 

[foxdev]

If you want more than what the script printing will provide, the only other built-in option I can think of is to add all the tables to the Database Diagram within Enterprise Manager.

Beyond that, you'll need to use some external tools, such as Visio or ERWin. Robert Bradley
Sr. DBA, some big company
cheap prints and oil paintings:

http://www.lowcostprints.com

 

[tlbroadbent]

You might want to consider using the Information Schema Views in SQL 7 and 2000. Check the following links.

MSDN: Information Schema Views

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_4pbn.asp

SWYNK.COM: Information Schema Views

http://www.swynk.com/friends/sharma/informationschema.asp

Terry

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

Neither success nor failure is ever final. -Roger Babson