Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRISOpens in a new window, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions pageOpens in a new window (login required).


Suppress/return error upon DROP of a nonexistent constraint.


[SQL]    DDLNo315=n


The value n may be 1 or 0:

  • If 1 (true) when an attempt is made to DROP a nonexistent constraint, Caché suppresses the SQLCODE -315 error.

  • If 0 (false) Caché returns the error.



Range of Values

0 or 1. The default is 0.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the Allow DDL DROP of Non-constraint setting, choose Yes (true) or No (false).

FeedbackOpens in a new window