InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 04:57:15 GMT20http://www.sqlservercentral.com/Forums/Topic772497-146-1.aspxthanks i'll look into Bi documentor also..--vijiTue, 18 Aug 2009 04:11:25 GMTAnamikahttp://www.sqlservercentral.com/Forums/Topic772497-146-1.aspxBI Documenter is also a pretty good tool. Creates a compiled HTML file.We use this to distribute schema documentation to clients.Tue, 18 Aug 2009 03:37:39 GMTClive Stronghttp://www.sqlservercentral.com/Forums/Topic772497-146-1.aspxthanks for the quick reply.i find some tools to do this and get the same into html format.right now i'm trying the samethanks,regardsvijiTue, 18 Aug 2009 03:35:24 GMTAnamikahttp://www.sqlservercentral.com/Forums/Topic772497-146-1.aspxVijiTypically a data dictionary contains info regarding tables, fkeys, indexes and also information regarding hard coded values in columns if any. Other than this it contains info regarding stored procedures, functions, and also user permissions and any other database features you have used. For ex: if you have used service broker you need to put that in also.Tue, 18 Aug 2009 03:25:55 GMTChiragNShttp://www.sqlservercentral.com/Forums/Topic772497-146-1.aspxHi all,i have to prepare a document about the details of our database. we may call it as data dictionary.Suggestions, ideas are welcome about what and all can be included to enrich the document.My idea is to give details about constraints, indexes, relationships between tables etc.thanks,regardsvijiTue, 18 Aug 2009 02:57:51 GMTAnamika