唯一约束

// Create a new table with columns and unnamed constraints
create.createTable("table")
      .column("column1", INTEGER)
      .column("column2", INTEGER)
      .column("column3", INTEGER)
      .unique("column1")
      .unique("column2", "column3")
      .execute();

// Equivalent to the above
create.createTable("table")
      .column("column1", INTEGER)
      .column("column2", INTEGER)
      .column("column3", INTEGER)
      .constraints(
          unique("column1"),
          unique("column2", "column3")
      )
      .execute();

// Create a new table with columns and named constraints (recommended if you want to alter the constraint)
create.createTable("table")
      .column("column1", INTEGER)
      .column("column2", INTEGER)
      .column("column3", INTEGER)
      .constraints(
          constraint("uk1").unique("column1"),
          constraint("uk2").unique("column2", "column3")
      )
      .execute();

createTable("table")
      .column("column1", INTEGER)
      .constraints(
          constraint("uk").unique("column1")
      )

CREATE TABLE table (
  column1 integer,
  CONSTRAINT uk UNIQUE (column1)
)

CREATE TABLE table (
  column1 int NULL,
  CONSTRAINT uk UNIQUE (column1)
)

CREATE TABLE table (
  column1 int,
  CONSTRAINT uk UNIQUE (column1)
)

CREATE TABLE table (
  column1 int64
)

CREATE TABLE table (
  column1 Nullable(integer)
)
ENGINE Log()

CREATE TABLE table (
  column1 int4,
  CONSTRAINT uk UNIQUE (column1)
)

CREATE TABLE table (
  column1 int,
  CONSTRAINT uk UNIQUE (column1)
)
TBLPROPERTIES(
  'delta.columnMapping.mode' = 'name',
  'delta.feature.allowColumnDefaults' = 'supported'
)

CREATE TABLE table (
  column1 integer,
  UNIQUE (column1) CONSTRAINT uk
)

CREATE TABLE table (
  column1 number(10),
  CONSTRAINT uk UNIQUE (column1)
)

CREATE TABLE table (
  column1 int,
  CONSTRAINT uk UNIQUE (column1) NOT ENFORCED
)

CREATE TABLE table (
  column1 int
)

使用 jOOQ 3.21 生成。早期 jOOQ 版本的支持可能有所不同。 在我们的网站上翻译您自己的 SQL