db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "CY Ing" <cy....@iasolution.net>
Subject RE: project-schema.sql... DROP with casacade?
Date Tue, 01 Apr 2003 05:45:26 GMT
Torque uses Velocity to generate DLLs, which is based on SQL template files.
For example, you can locate Oracle DROP template at
<torque>\templates\sql\base\oracle\drop.vm. It looks like this:

DROP TABLE $table.Name CASCADE CONSTRAINTS;
#if ($table.IdMethod == "native")
DROP SEQUENCE $table.SequenceName;
#end


Just modify to get what you need. When you done, regenerate the DDL and see
what happens.

Regards.

-----Original Message-----
From: Jeff cox [mailto:Jeff@cwindustries.net]
Sent: Tuesday, April 01, 2003 11:19 AM
To: 'Turbine Torque Users List'
Subject: project-schema.sql... DROP with casacade?


Hi,
	Just curious... is there a way to get 'CASCADE' appended to the
DROP statements in the generated DDL file. Most of my tables have
foreign keys associated with them, and thus fail to execute when running
the insert-sql build task. Alternativly, if there is a better way to
handle without using CASCADE, any help would be appreciated...

Jeff



---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message