CREATE TABLE test6
   (
      id         INT IDENTITY(1, 1),
      NAME       VARCHAR(50),
      valid_from DATETIME,
      valid_to   DATETIME,
      CONSTRAINT check_valid_to  CHECK (valid_to > valid_from)
   )