harsha.bhagat1 (3/1/2011)
Thank you for the reply,But I think I am not being able to make clear what I actually want.
In simple terms I want to document the database into word file. I work in sql server 2000.
I want to write a procedure or generate a script which I execute it and then a word file gets created with all the tables and its column explanation.
Thanks,
Harsha
or maybe you wanted to just generate the lsit of tables/columns like this?:
select objz.name as TableName,
colz.name as ColumnName,
colz.colid
from sysobjects objz
inner join syscolumns colz
on objz.id = colz.id
WHERE objz.xtype='U'
ORDER BY objz.name,colz.colid
Lowell