On Wed, 14 May 2003, Kuhn, Dylan K (4520500D) wrote:
> We use a version-controlled model for our database design, and would
> like to know what model version any particular database implements. A
> client can thereby determine by the model version if it is able to use
> the database.
I use a special table called "schema" that holds a one-row entry with
the schema version number. The upgrade scripts can extract the
existing schema and do any necessary adjustments to bring the schema
up-to-date.
It's not sophisticated, but it works.
--
David.