Unless you somehow have circular references, you can programatically
find the relationships and follow them all down to the tables that
hold no foreign keys, and work backwards.

OR

You could remove all constraints, add the table data, and readd the
constraints. I think this is how gbak restores a database.

Jason


--- In firebird-support@yahoogroups.com, "Myles Wakeham" <myles@t...>
wrote:

> I have to copy a series of about 40 tables from an ODBC data source

into a

> Firebird SQL database everynight at 12 midnight. This is a 'Data

Warehouse'

> dump of information from a transactional system to Firebird. All data in
> Firebird that was there before, can be completely deleted but I'd

like to

> keep the table structure intact.
>
> I thought this would be a simple DELETE * from TABLE NAME for each table
> that has to be transferred over, but there are primary/foreign key
> relationships between the tables and therefore I can't delete out

the tables

> without upsetting the data integrity in the database.
>
> What is the best practice in these situations?
>
> Myles
>
> ===========================
> Myles Wakeham
> Director of Engineering
> Tech Solutions Inc.
> Scottsdale, Arizona USA
> Phone (480) 451-7440
> Web: www.techsol.org