Subject Best way to run metadata update scripts
Author fakuva

I have an application that connects to an firebird database with ADO
(Delphi) throug ODBC. This application need to add a couple of new
tables with foreign keys and add some columns to already existing table.

Currently I'm sending these DDL commands one by one using a ADOCommand
component, but this creates a lot of problem. For instance I get an
error indicating that the table is in use when I try to create a
foreign key etc.

I'm wondering what the best practice is when you want to perform such
operations and it must be integrated into an application?

best regards,
Bjørn Larsen