documenting tables and fields - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

documenting tables and fields

Author

Topic

lalbatros
Yak Posting Veteran

69 Posts

Posted - 2008-06-10 : 03:30:29

Hello,

I would like to create some documentation for my database(s) in sql2000 or sql2005.
I would need a list containing all tables, all fields from these tables, and all properties of these fields. Of course all the information should be "in clear", easy to read.

Thanks if could help me getting such a report.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-10 : 03:52:40

SELECT * FROM INFORMATION_SCHEMA.COLUMNS will give you all fields in all tables of db.
By properties, what all do you mean to retrive?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-10 : 03:58:30

view this link too

http://msdn.microsoft.com/en-us/library/ms186778.aspx

lalbatros
Yak Posting Veteran

69 Posts

Posted - 2008-06-10 : 05:35:32

Thanks visakh16,

Would you know where I can find properties like "indentity specifications" ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-10 : 06:31:24

quote:
Originally posted by lalbatros

Thanks visakh16,

Would you know where I can find properties like "indentity specifications" ?

Did you mean identity?

lalbatros
Yak Posting Veteran

69 Posts

Posted - 2008-06-10 : 06:55:54

Yes, and also the "increment"

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-06-10 : 07:31:11

select syscolumns.Name [Identity Column], sysobjects.Name [Table]
from syscolumns
inner join sysobjects on sysColumns.id = sysObjects.id
where autoval is not null

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources