MSCEWI3041

Enable/disable constraint state removed from not null inline constraint.

Severity

Low

Description

ENABLE/DISABLE keyword was removed from a NOT NULL column definition.

Example Code

Input Code:

CREATE TABLE TABLE1
(
    COLUMN1 NUMBER NOT NULL ENABLE
);

Output Code:

CREATE OR REPLACE TABLE PUBLIC.TABLE1 (
COLUMN1 NUMBER (38,19) NOT NULL /*** MSC-WARNING - MSCEWI3041 - ENABLE/DISABLE CONSTRAINT STATE REMOVED FROM NOT NULL INLINE CONSTRAINT ***/);

Recommendations