Skip to main content


Suppress error upon DROP of a nonexistent constraint.


[SQL]    DDLNo315=n

n is either 1 or 0. The default value is 0.


When DDLNo315 is enabled (n = 1), when an attempt is made to DROP a nonexistent constraint, InterSystems IRIS® data platform suppresses the SQLCODE -315 error.

For further details, refer to the ALTER TABLE command.

Changing This Parameter

On the SQL page of the Management Portal (System Administration > Configuration > SQL and Object Settings > SQL), select Ignore redundant DDL statements to suppress redundant SQLCODE errors.

You can also change DDLNo315 with the Config.SQLOpens in a new tab class (as described in the class reference) or by editing the CPF in a text editor (as described in Editing the Active CPF).

FeedbackOpens in a new tab