Local temporary tables

// Create a new temporary table
create.createLocalTemporaryTable("book_archive")
      .column("column1", INTEGER)
      .execute();

The SQL standard also specifies a LOCAL TEMPORARY syntax with a different semantics, where the locality is with respect to a "SQL module," not a session or transaction. Many RDBMS use the keyword LOCAL with a different meaning from the standard, and thus jOOQ follows the implementations here, not the standard.

// Create a new temporary table
create.createTemporaryTable("book_archive")
      .column("column1", INTEGER)
      .execute();

This alternative syntax is still supported, but no longer recommended with jOOQ 3.21, as the two types of temporary tables work quite differently.

createLocalTemporaryTable("book_archive")
      .column("column1", INTEGER)

CREATE TEMPORARY TABLE book_archive (
  column1 int
)

CREATE TEMPORARY TABLE book_archive (
  column1 int64
)

CREATE TEMPORARY TABLE book_archive (
  column1 Nullable(integer)
)
ENGINE Log()

CREATE TEMPORARY TABLE book_archive (
  column1 int4
)

DECLARE GLOBAL TEMPORARY TABLE book_archive (
  column1 integer
)

CREATE LOCAL TEMPORARY TABLE book_archive (
  column1 int
)

CREATE LOCAL TEMPORARY TABLE book_archive (
  column1 integer
)

CREATE PRIVATE TEMPORARY TABLE book_archive (
  column1 number(10)
)

CREATE TEMPORARY TABLE book_archive (
  column1 number(10)
)

CREATE TABLE #book_archive (
  column1 int
)

/* UNSUPPORTED */

Generated with jOOQ 3.21. Support in older jOOQ versions may differ. Translate your own SQL on our website