Subject Best place to store schema version for use by update procedures?
Author mlq97
Where is the best place to store the schema version of a database? At
present I have created a 1 row table with a column to store the number.

But when comparing two schemas to automatically create an update
script, the schema numbers are not automatically visible.

Is there a better way to do this, perhaps in a constant or something?

What is the standard way of doing this?