Print report of Database

[elibb]

hi, is there a way to print a report with all the tables and fields i have in my database? kind of the one you can print in Access?

thank you very much

Eli

 

[clapag22]

Not really... You could make a view accessing the system tables SYSOBJECTS and SYSCOLUMNS and then link that view to Access (or Crystal or whatever you like) and print it out from there... Someone will probably yell at me for telling you to access the system tables, however...

Start of the view:

select o.name as TbName, c.name as ColName
from sysobjects o, syscolumns c
where o.id = c.id
order by 1, 2

 

[SQLBill]

You can also use Enterprise Manager. Drill down to the database and right-click. Select New, then select Database Diagram. Use the wizard and diagram your database. Then print it.

-SQLBill

 

[elibb]

i tried to create a diagram, but i couldnt see all the fields in my tables, and i couldnt put any relations there. (i just want the relations in my diagram, i dont really use them in the database)

thank you very much

Eli