Skip to Content

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.

http://iablog.sybase.com/efarrar/wp-content/uploads/2011/06/doc1.PNG

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.

http://iablog.sybase.com/efarrar/wp-content/uploads/2011/06/doc2.PNG

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Anonymous
    It’s nice, but i found one problem. If stored procedures are in Transact-SQL syntax, and one procedure executes another, then it won’t be documented. It means that right now the “called by” and “calls” segments are incomplete.  Is it a bug or a feature I don’t know, bu I hope it’s a bug and will be fixed
    (0) 

Leave a Reply