http://www.symfony-project.org/forum/index.php/m/30176/

I am using Microsoft SQL Server 2000, and can get propel to connect fine.

However, when I run propel-build-sql, the sql is generated so that the ALTER TABLE commands are located in amongst the file before all the tables have been created - this generates 'table not found' errors as there are references to tables not yet created.

E.g. instead of (code simplified for illustration):

CREATE TABLE table_1
CREATE TABLE table_2
ALTER TABLE table 1 ADD CONSTRAINT table_1_FK_1 FOREIGN KEY table_2_id REFERENCES table_2

I get:

CREATE TABLE table_1
ALTER TABLE table 1 ADD CONSTRAINT table_1_FK_1 FOREIGN KEY table_2_id REFERENCES table_2
CREATE TABLE table_2

At the moment I can solve this by manually moving all the ALTER TABLE statements to the end of the sql file, but this is slightly laborious, and obviously prevents propel-insert-sql from working at all.

Does anyone know a way to get the sql to generate correctly?