# E141-02: UNIQUE constraints of NOT NULL columns

statement ok
CREATE TABLE TABLE_E141_02_01_01 ( ID INT PRIMARY KEY, A INT NOT NULL, B INT NOT NULL, CONSTRAINT CONST_E141_02_01_01 UNIQUE ( A ) )

statement ok
CREATE TABLE TABLE_E141_02_01_02 ( ID INT PRIMARY KEY, A INT NOT NULL, B INT NOT NULL, CONSTRAINT CONST_E141_02_01_02 UNIQUE ( A , B ) )

statement ok
CREATE TABLE TABLE_E141_02_01_03 ( ID INT PRIMARY KEY, A INT NOT NULL, B INT NOT NULL, UNIQUE ( A ) )

statement ok
CREATE TABLE TABLE_E141_02_01_04 ( ID INT PRIMARY KEY, A INT NOT NULL, B INT NOT NULL, UNIQUE ( A , B ) )

statement ok
CREATE TABLE TABLE_E141_02_02_01 ( ID INT PRIMARY KEY, A INT NOT NULL CONSTRAINT CONST_E141_02_02_01 UNIQUE )

statement ok
CREATE TABLE TABLE_E141_02_02_02 ( ID INT PRIMARY KEY, A INT NOT NULL UNIQUE )
