Database Documentation

As a database grows (in terms of tables, constraints, triggers, indexes,...), it becomes more and more difficult to keep the overview over all those tiny details one has implemented.

I thought of some way to automatically generate database documentation:

• select <objects> from user_objects
• for each of those objects
  • select and nicely format the code...
• print it out

What is your way to keep the oversight? What is your way do document the database, e.g. for new administrators, when you are changing your job :-)

   Martin Berli

Internet: berli_at_switch.ch  | SWITCH, Swiss Academic and Research Network
Phone   : +41 1 268 1540   | Limmatquai 138
Fax     : +41 1 268 1568   | CH-8001 Zurich