primaryKey
@Support
@NotNull
@CheckReturnValue
@NotNull CreateTableElementListStep primaryKey(@Name
String... fields)
Add the
PRIMARY KEY
clause to the CREATE TABLE
statement.Attachable
, AttachableQueryPart
, CreateTableAsStep
, CreateTableCommentStep
, CreateTableFinalStep
, CreateTableOnCommitStep
, CreateTableStorageStep
, DDLQuery
, Flow.Publisher<Integer>
, Publisher<Integer>
, org.reactivestreams.Publisher<Integer>
, Query
, QueryPart
, RowCountQuery
, Serializable
, Statement
CREATE TABLE
statement.
XYZ*Step
types directly from client code
It is usually not recommended to reference any XYZ*Step
types
directly from client code, or assign them to local variables. When writing
dynamic SQL, creating a statement's components dynamically, and passing them
to the DSL API statically is usually a better choice. See the manual's
section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.
Drawbacks of referencing the XYZ*Step
types directly:
@NotNull CreateTableElementListStep
CHECK
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
COLUMN
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
COLUMN
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
COLUMN
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
COLUMN
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
COLUMNS
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
columns(Collection<? extends Field<?>> columns)
COLUMNS
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
COLUMNS
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
COLUMNS
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
constraint(Constraint constraint)
CONSTRAINT
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
constraints(Collection<? extends Constraint> constraints)
CONSTRAINTS
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
constraints(Constraint... constraints)
CONSTRAINTS
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
INDEX
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
indexes(Collection<? extends Index> indexes)
INDEXES
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
INDEXES
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
primaryKey(String... fields)
PRIMARY KEY
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
primaryKey(Collection<? extends Field<?>> fields)
PRIMARY KEY
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
primaryKey(Field<?>... fields)
PRIMARY KEY
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
primaryKey(Name... fields)
PRIMARY KEY
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
tableElements(Collection<? extends TableElement> tableElements)
TABLE ELEMENTS
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
tableElements(TableElement... tableElements)
TABLE ELEMENTS
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
UNIQUE
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
unique(Collection<? extends Field<?>> fields)
UNIQUE
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
UNIQUE
clause to the CREATE TABLE
statement.@NotNull CreateTableElementListStep
UNIQUE
clause to the CREATE TABLE
statement.attach, configuration, detach
getBindValues, getParam, getParams, getSQL, getSQL
as
comment, comment
onCommitDeleteRows, onCommitDrop, onCommitPreserveRows
storage, storage, storage, storage
subscribe
bind, bind, cancel, execute, executeAsync, executeAsync, isExecutable, keepStatement, poolable, queryTimeout
TABLE ELEMENTS
clause to the CREATE TABLE
statement.TABLE ELEMENTS
clause to the CREATE TABLE
statement.COLUMNS
clause to the CREATE TABLE
statement.COLUMNS
clause to the CREATE TABLE
statement.COLUMNS
clause to the CREATE TABLE
statement.COLUMNS
clause to the CREATE TABLE
statement.COLUMN
clause to the CREATE TABLE
statement.COLUMN
clause to the CREATE TABLE
statement.COLUMN
clause to the CREATE TABLE
statement.COLUMN
clause to the CREATE TABLE
statement.CONSTRAINTS
clause to the CREATE TABLE
statement.CONSTRAINTS
clause to the CREATE TABLE
statement.CONSTRAINT
clause to the CREATE TABLE
statement.PRIMARY KEY
clause to the CREATE TABLE
statement.PRIMARY KEY
clause to the CREATE TABLE
statement.PRIMARY KEY
clause to the CREATE TABLE
statement.PRIMARY KEY
clause to the CREATE TABLE
statement.UNIQUE
clause to the CREATE TABLE
statement.UNIQUE
clause to the CREATE TABLE
statement.UNIQUE
clause to the CREATE TABLE
statement.UNIQUE
clause to the CREATE TABLE
statement.CHECK
clause to the CREATE TABLE
statement.INDEXES
clause to the CREATE TABLE
statement.INDEXES
clause to the CREATE TABLE
statement.INDEX
clause to the CREATE TABLE
statement.