Feature Request: Check exists before drop in DDL

[jcedwards]

Hello,

I'm using the data modeling features of EA (great product btw) to model some tables in Firebird databases. The problem is that the DDL script generated when I check the "Create Drop Statements (sic)" option doesn't include "exists" checks. I need the script that's generated to check that a constraint/table actually exists before it is dropped. Microsoft's SQL Enterprise Manager does this when you create scripts for SQL Server 2000 databases. I'm not sure if Firebird supports INFORMATION_SCHEMA, but I would think there has to be some way a Firebird database can check for existing constraints and tables before dropping them, allowing EA to generate this code.

Is this already a known issue? Was there a design constraint in EA that made this scenario not an issue? Any info would be great.

Thanks,

-Jayme