MSCEWI3041
Enable/disable constraint state removed from not null inline constraint.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
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
No additional user actions are required.
If you need more support, you can email us at [email protected]
Last updated