> We've talked about this in the past, but the best way to handle DDL
> changes is through an UPGRADE (or CREATE OR ALTER) statement where a
> single function performs the CREATE and UPGRADE operations. This
> mechanism guarantees that anything that can be defined can be altered
> (assuming, of course, that the alternation is itself legal). We would
> continue, of course, to support ALTER in all of its legacy ugliness, but
> UPGRADE would be the catch-all.

Well then, first create the UPGRADE command then start talking about
removing system table "activeness" :-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com