Where I work, one guy wrote a perl script that uses a data dictionary to generate sql and C code for out application. The sql that is generated by the perl script is used to create the database based on the data dictionary. This include all the indexes and things like that. Of course there is stored procedures that are made the old fashoned way. The C code is used in the C programming we do. We have a generic table API that you call this function pass it the table name and the operation and the key index (0, 1, 2 etc) and then it fills up a structure that was also generated by the perl script. All this allows us to make changes to the data dictionary then run this script and build new databases out of it. Kinda cool.