• Home
• us.fatehi
• schemacrawler-testdb
• 16.24.2
• source code
• 11_domains_A.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.books.11_domains_A.sql Maven / Gradle / Ivy

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

-- Table using domains
CREATE TABLE CustomerData
(
  Id INTEGER NOT NULL,  
  Data VALID_STRING,
  CONSTRAINT PK_CustomerData PRIMARY KEY (Id)
)
;