db.for_lint.for_lint.post_schema.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of schemacrawler-testdb Show documentation

The newest version!

-- Remarks
COMMENT ON TABLE EXTRA_PK IS 'Extra table with just a primary key'
;
COMMENT ON COLUMN PUBLICATIONS.TITLE IS 'Publication title'
;

-- Domains
CREATE DOMAIN VALID_STRING AS VARCHAR(20) DEFAULT 'NO VALUE' CHECK (VALUE IS NOT NULL AND CHARACTER_LENGTH(VALUE) > 2);

-- Temporary table
CREATE GLOBAL TEMPORARY TABLE TEMP1
(
  ID INT PRIMARY KEY, 
  SCORES INT ARRAY DEFAULT ARRAY[], 
  NAMES VARCHAR(20) ARRAY[10], 
  DATA VALID_STRING
)
ON COMMIT DELETE ROWS;