Automate Schema Relationship changes?

[TheLagosChap]

Hi

Is there any way (Applescript, SQL via Filemaker ODBC or anything else) to automate the modification of a Filemaker database schema?

I know that SQL CREATE TABLE and ALTER TABLE are possible but I am also looking at creating/modifying RELATIONSHIPS between tables. I do not think this is possible via SQL.

The purpose is to automate the upgrade of a Filemaker database (vs. repeating each change manually using the "Manage Database..." dialogs).

Thanks!