db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Graham Leggett <minf...@sharp.fm>
Subject Table creation: drop table / create table
Date Fri, 25 Apr 2003 17:49:50 GMT
Hi all,

In the current sql script that is generated for the database schema, 
each create table command is preceeded with a drop table command.

If foreign keys are used in the tables, these drop table commands fail, 
as tables refering to them have not been dropped yet. The correct 
behaviour should be (in theory) that dropped tables should be dropped in 
the reverse order in which they were created - thus guaranteeing that 
tables with foreign keys are dropped first.

Thoughts?

Regards,
Graham
-- 
-----------------------------------------
minfrin@sharp.fm		"There's a moon
					over Bourbon Street
						tonight..."


Mime
View raw message