Currently when I generate DDL using org.hibernate.tool.hbm2ddl.SchemaExportTask I get this:

alter table ATTRS drop constraint PARENT_ID_FK;

I would like the DDL to check for existence first like this:

if exists
(select * from sysobjects where id = object_id('PARENT_ID_FK')
and OBJECTPROPERTY(id, N'IsConstraint') = 1)
ALTER TABLE ATTRS DROP CONSTRAINT PARENT_ID_FK

Is there a way to do this? Maybe by configuring SchemaExportTask or the mapping XML files?

I'm using the SQL Server dialect.

Thx,

Dan