schema versioning

[andreasen]

I am new to DB development, so please excuse the question. I have a DB that will likely evolve with future product releases. How do I check for the version of the schema/DB that is active in an application instance to be able to modify the logic accordingly in the app?
I know I can create a table with this information, but it seems a lot of unnecessary overhead since it will only have a single row.
Thanks
-b

[TheCPUWizard]

A table is probably the best way to go. Rather than have (potentially lots of) tables with only a single row/field. You can use the "Junk Draw" approach


Schema

ID AutoNumber
Key String / Indexed / Unique
Value String



Now you can put all of your handy DB-centric variables in one nice little table.