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