Database Documentation with SQL Anywhere
With all of the features that have been added to SQL Anywhere over last few versions, one feature that may have slipped being noticed is the ability to automatically generate database documentation (example). This feature was first introduced in SQL Anywhere 11, and then later enhanced in SQL Anywhwere 12. Database documentation is useful for checking into source control, giving to new developer, and in some cases, distributing to customers.
The documentation wizard will generate HTML based documentation for all of your:
- events
- functions
- procedures
- tables
- triggers
- views
To try out the documentation wizard, connect to your database using Sybase Central. Right click on the database, and select Generate Database Documentation… from the context menu.
This will bring up the Database Documentation Wizard. The wizard will allow you to filter the objects that you want to document, and choose where you want the documentation saved.
