Boolean Sütun Tipleri

1. BIT
Şöyle yaparız.

BIT(1) DEFAULT b'1'

2. BOOLEAN

Şöyle yaparız

CREATE TABLE IF NOT EXISTS ADV.ID_GENERATOR
(
    name      VARCHAR(40),
    value     INTEGER,
    increment INTEGER DEFAULT 1,
    max_value INTEGER,
    cyclic    BOOLEAN DEFAULT 1, -- here
    region_id INT
);

Örnek

Şöyle yaparız

CREATE TABLE foo (
  v VARCHAR(100),
  b BOOLEAN,
  ti TINYINT,
  si SMALLINT,
  i INTEGER,
  bi BIGINT,
  dc DECIMAL,
  r REAL,
  dbl DOUBLE,
  tm TIME,
  dt DATE,
  ts TIMESTAMP,
  tstz TIMESTAMP WITH TIME ZONE
);