Myles,

> Has anyone found a way to version stamp the DDL within a Firebird
> database?

We created a simple SP named "Get_Schema_Version" which returns a
constant version string that we have assigned.

Then, whenever we make a change to the schema, we include a CREATE OR
ALTER PROCEDURE statement, in the SQL script which update the target
DBs, to update the SP version string value.

So, that on startup our Application runs the SP and compares the
returned string against the value it needs/expects.


Sean