Documenting Database Schema.

[mukund]

Hi,
Has anybody written a script that can help me document my table's structure.

Say in the following format

TableName : RadioStation

FieldName PK/FK DataType
-----------------------------------------------------
RadioStationId PK int
CountryId FK (Country) smallint
LangId FK (Language) smallint
AddrId FK (Address) int
RadioStationname varchar(100)



For a foreign key the PK table is depicted in brackets.

If anybody has already done something like this, it can help a lot towards documentation of the Database Schema.

Any help/suggetions is welcome.

Mukund.

 

[AshleyRickards]

What you could do is script your database. Right click on the database in EM and select all tasks, Generate SQL Script. You could then refomat as needed. Ashley L Rickards
SQL DBA

 

[chrislarkin]

If you have Microsoft Visio, you can create a schema by importing the database structure. It'll even look pretty when you are done

 

[moonshadow]

If you're using SQL 7 or above, you can get it to automatically build a database diagram. Open up the database in Enterprise Manager, select diagrams, right click select new diagram, it's all fairly intuitive.

 

[AshleyRickards]

How do you import into Visio? Thanks. Ashley L Rickards
SQL DBA

 

[pwills]

Look at the INFORMATION_SCHEMA views in SQL Server, which document the database automatically.