WITHOUT OVERLAPS

Description

BUSINESS_TIME WITHOUT OVERLAPS means that for the other specified keys, the values are unique with respect to time for the BUSINESS_TIME period

Click here to navigate to the IBM DB2 docs page for this syntax.

BUSINESS_TIME WITHOUT OVERLAPS Constraint attribute are removed because they are not applicable in Snowflake.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code

CREATE TABLE T1
(
COL1 VARCHAR(10),
CONSTRAINT ConstraintName UNIQUE (COL1, COL2, BUSINESS_TIME WITHOUT OVERLAPS)
);

Snowflake

Code

CREATE TABLE T1
(
COL1 VARCHAR(10),
CONSTRAINT ConstraintName UNIQUE (COL1, COL2
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  **
--                                            , BUSINESS_TIME WITHOUT OVERLAPS
                                                                            )
);

Known issues

There are no known issues.