Documenting a database schema
852547Oct 11 2011 — edited Oct 11 2011Hi Folks,
I am wondering what is the standard way of documenting a database schema ?
We have a ca. 200 table database schema here and our DBA has always documented it in a MS word document.
In other words there is a huge word document that is occasionally updated that contains all the table / column details and what the table is for.
One has to go looking for the doc and then search for a table.
Surely there is a better way than this - for example in Oracle SQL Developer when browsing a table I see the Details tab and Comments.
Would that be appropriate to use and if so how is it populated.
Or how do other folks deal with this ?
Any Help Appreciated
Peter