[SQL] NOT NULL ENABLE / NOT NULL DISABLE

 

NOT NULL ENABLE  의미 :  NOT NULL

CREATE TABLE FOO (PRIORITY_LEVEL NUMBER DEFAULT 42 NOT NULL ENABLE);
-- 아래와 같다
CREATE TABLE FOO (PRIORITY_LEVEL NUMBER DEFAULT 42 NOT NULL);

NOT NULL DISABLE  의미 :  NULL

CREATE TABLE FOO (PRIORITY_LEVEL NUMBER DEFAULT 42 NOT NULL DISABLE);
-- 아래와 같다
CREATE TABLE FOO (PRIORITY_LEVEL NUMBER NULL);

 

출처 :https://stackoverflow.com/questions/20595008/is-there-a-difference-between-not-null-and-not-null-enable

Is there a difference between "not null" and "not null enable"?