Uses of Interface
org.jooq.Name
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of Name in org.jooq
Modifier and TypeMethodDescription@NotNull Name
Link.$name()
Experimental query object model accessor method, see alsoQOM
.@NotNull Name
Named.$name()
Experimental query object model accessor method, see alsoQOM
.@NotNull Name
WindowDefinition.$name()
Experimental query object model accessor method, see alsoQOM
.@NotNull Name
DerivedColumnList.$tableName()
Experimental query object model accessor method, see alsoQOM
.@NotNull Name
Appendsname
to this name.@NotNull Name
Appendsname
(all of itsparts()
) to this name.@NotNull Name
Named.getQualifiedName()
The qualified name of this object.@NotNull Name
Named.getUnqualifiedName()
The unqualified name of this object.@NotNull Name
ParseContext.parseIdentifier()
Parse an (unqualified) identifier or fail if the current token is not an identifier.@Nullable Name
ParseContext.parseIdentifierIf()
Try parsing an (unqualified) identifier.@NotNull Name
ParseContext.parseName()
Parse a name (a qualified identifier) or fail if the current token is not a name.@NotNull Name
Parse a SQL string to a name.@NotNull Name
Parse a SQL string with bind variables to a name.@Nullable Name
ParseContext.parseNameIf()
Try parsing a name (a qualified identifier).@NotNull Name @NotNull []
Name.parts()
Get the individual, unqualified name parts of this name.@Nullable Name
Name.qualifier()
This name's qualifier (if it isqualified()
), ornull
.@NotNull Name
Name.quotedName()
This name, quoted.final Name
DatePart.toName()
@NotNull Name
Name.unqualifiedName()
This name, unqualified.@NotNull Name
Name.unquotedName()
This name, unquoted.Modifier and TypeMethodDescription@NotNull QOM.UnmodifiableList<? extends Name>
DerivedColumnList.$columnNames()
Experimental query object model accessor method, see alsoQOM
.Modifier and TypeMethodDescription@NotNull AlterTableAddStep
Add anADD COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
Add anADD COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
AlterTableStep.addColumnIfNotExists
(Name field, DataType<?> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableAddStep
AlterTableStep.addIfNotExists
(Name field, DataType<?> type) Add anADD COLUMN IF NOT EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableFinalStep
Add aAFTER
clause toALTER TABLE … ADD …
.@NotNull AlterTableAlterStep<Object>
Add anALTER COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAlterStep<Object>
AlterTableStep.alterColumn
(Name field) Add anALTER COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableAlterConstraintStep
AlterTableStep.alterConstraint
(Name constraint) Add anALTER CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterDatabaseStep
DSLContext.alterDatabase
(Name database) TheALTER DATABASE
statement.@NotNull AlterDatabaseStep
DSLContext.alterDatabaseIfExists
(Name database) TheALTER DATABASE IF EXISTS
statement.<T> @NotNull AlterDomainStep<T>
DSLContext.alterDomain
(Name domain) TheALTER DOMAIN
statement.<T> @NotNull AlterDomainStep<T>
DSLContext.alterDomainIfExists
(Name domain) TheALTER DOMAIN IF EXISTS
statement.@NotNull AlterIndexOnStep
DSLContext.alterIndex
(Name index) TheALTER INDEX
statement.@NotNull AlterIndexOnStep
DSLContext.alterIndexIfExists
(Name index) TheALTER INDEX IF EXISTS
statement.@NotNull AlterViewStep
DSLContext.alterMaterializedView
(Name view) TheALTER MATERIALIZED VIEW
statement.@NotNull AlterViewStep
DSLContext.alterMaterializedViewIfExists
(Name view) TheALTER MATERIALIZED VIEW IF EXISTS
statement.@NotNull AlterSchemaStep
DSLContext.alterSchema
(Name schema) TheALTER SCHEMA
statement.@NotNull AlterSchemaStep
DSLContext.alterSchemaIfExists
(Name schema) TheALTER SCHEMA IF EXISTS
statement.@NotNull AlterSequenceStep<Number>
DSLContext.alterSequence
(Name sequence) TheALTER SEQUENCE
statement.@NotNull AlterSequenceStep<Number>
DSLContext.alterSequenceIfExists
(Name sequence) TheALTER SEQUENCE IF EXISTS
statement.@NotNull AlterTableStep
DSLContext.alterTable
(Name table) Create a new DSLALTER TABLE
statement.@NotNull AlterTableStep
DSLContext.alterTableIfExists
(Name table) Create a new DSLALTER TABLE
statement.@NotNull AlterTypeStep
TheALTER TYPE
statement.@NotNull AlterTypeStep
DSLContext.alterTypeIfExists
(Name type) TheALTER TYPE IF EXISTS
statement.@NotNull AlterViewStep
TheALTER VIEW
statement.@NotNull AlterViewStep
DSLContext.alterViewIfExists
(Name view) TheALTER VIEW IF EXISTS
statement.@NotNull Name
Appendsname
(all of itsparts()
) to this name.@NotNull SelectField<T>
Create an alias for this field.Create an alias for this table.Table.as
(Name alias, Collection<? extends Name> fieldAliases) Create an alias for this table and its fields.Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.Create an alias for this table and its fields.TableLike.asMultiset
(Name alias) Turn thisTableLike
expression into aDSL.multiset(TableLike)
.The underlying aliased table representation of this object.TableLike.asTable
(Name alias, Collection<? extends Name> fieldAliases) The underlying aliased table representation of this object.The underlying aliased table representation of this object.A table reference of this table at a givenLink
.@NotNull AlterTableFinalStep
Add aBEFORE
clause toALTER TABLE … ADD …
.@NotNull CallArgsStep
TheCALL
statement.boolean
Check if a field's value has been changed from its original as fetched from the database, usingFields.field(Name)
for lookup.void
Set this record's internal changed flag to the supplied value for a given field, usingFields.field(Name)
for lookup.Apply a collation operator to this column expression.@NotNull CreateTableElementListStep
Add theCOLUMN
clause to theCREATE TABLE
statement.@NotNull JSONTableColumnForOrdinalityStep
Add a column to theCOLUMNS
clause of theJSON_TABLE
expression.@NotNull JSONTableColumnPathStep
Add a column to theCOLUMNS
clause of theJSON_TABLE
expression.@NotNull XMLTableColumnForOrdinalityStep
Add a column to theCOLUMNS
clause of theXMLTABLE
expression.@NotNull XMLTableColumnPathStep
Add a column to theCOLUMNS
clause of theXMLTABLE
expression.@NotNull CreateTableElementListStep
Add theCOLUMNS
clause to theCREATE TABLE
statement.@NotNull CommentOnIsStep
DSLContext.commentOnColumn
(Name field) TheCOMMENT ON COLUMN
statement.@NotNull CommentOnIsStep
DSLContext.commentOnMaterializedView
(Name view) TheCOMMENT ON MATERIALIZED VIEW
statement.@NotNull CommentOnIsStep
DSLContext.commentOnTable
(Name table) TheCOMMENT ON TABLE
statement.@NotNull CommentOnIsStep
DSLContext.commentOnView
(Name view) TheCOMMENT ON VIEW
statement.int
Compare twounquotedName()
by their qualified string versions.@NotNull CreateDatabaseFinalStep
DSLContext.createDatabase
(Name database) TheCREATE DATABASE
statement.@NotNull CreateDatabaseFinalStep
DSLContext.createDatabaseIfNotExists
(Name database) TheCREATE DATABASE IF NOT EXISTS
statement.@NotNull CreateDomainAsStep
DSLContext.createDomain
(Name domain) TheCREATE DOMAIN
statement.@NotNull CreateDomainAsStep
DSLContext.createDomainIfNotExists
(Name domain) TheCREATE DOMAIN IF NOT EXISTS
statement.@NotNull CreateFunctionParametersStep
DSLContext.createFunction
(Name function) TheCREATE FUNCTION
statement.@NotNull CreateTableElementListStep
DSLContext.createGlobalTemporaryTable
(Name table) TheCREATE GLOBAL TEMPORARY TABLE
statement.@NotNull CreateTableElementListStep
DSLContext.createGlobalTemporaryTableIfNotExists
(Name table) TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.@NotNull CreateIndexStep
DSLContext.createIndex
(Name index) TheCREATE INDEX
statement.@NotNull CreateIndexStep
DSLContext.createIndexIfNotExists
(Name index) TheCREATE INDEX IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedView
(Name view, Name... fields) TheCREATE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedViewIfNotExists
(Name view, Name... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.@NotNull CreateFunctionParametersStep
DSLContext.createOrReplaceFunction
(Name function) TheCREATE OR REPLACE FUNCTION
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceMaterializedView
(Name view, Name... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.@NotNull CreateProcedureParametersStep
DSLContext.createOrReplaceProcedure
(Name procedure) TheCREATE OR REPLACE PROCEDURE
statement.@NotNull CreateTriggerEventStep
DSLContext.createOrReplaceTrigger
(Name trigger) TheCREATE OR REPLACE TRIGGER
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Name view, Name... fields) TheCREATE OR REPLACE VIEW
statement.@NotNull CreateProcedureParametersStep
DSLContext.createProcedure
(Name procedure) TheCREATE PROCEDURE
statement.@NotNull CreateSchemaFinalStep
DSLContext.createSchema
(Name schema) TheCREATE SCHEMA
statement.@NotNull CreateSchemaFinalStep
DSLContext.createSchemaIfNotExists
(Name schema) TheCREATE SCHEMA IF NOT EXISTS
statement.@NotNull CreateSequenceFlagsStep
DSLContext.createSequence
(Name sequence) TheCREATE SEQUENCE
statement.@NotNull CreateSequenceFlagsStep
DSLContext.createSequenceIfNotExists
(Name sequence) TheCREATE SEQUENCE IF NOT EXISTS
statement.@NotNull CreateTableElementListStep
DSLContext.createTable
(Name table) TheCREATE TABLE
statement.@NotNull CreateTableElementListStep
DSLContext.createTableIfNotExists
(Name table) TheCREATE TABLE IF NOT EXISTS
statement.@NotNull CreateTableElementListStep
DSLContext.createTemporaryTable
(Name table) TheCREATE TEMPORARY TABLE
statement.@NotNull CreateTableElementListStep
DSLContext.createTemporaryTableIfNotExists
(Name table) TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.@NotNull CreateTriggerEventStep
DSLContext.createTrigger
(Name trigger) TheCREATE TRIGGER
statement.@NotNull CreateTypeStep
DSLContext.createType
(Name type) TheCREATE TYPE
statement.@NotNull CreateTypeStep
DSLContext.createTypeIfNotExists
(Name type) TheCREATE TYPE IF NOT EXISTS
statement.@NotNull CreateIndexStep
DSLContext.createUniqueIndex
(Name index) TheCREATE UNIQUE INDEX
statement.@NotNull CreateIndexStep
DSLContext.createUniqueIndexIfNotExists
(Name index) TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Name view, Collection<? extends Name> fields) TheCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Name view, Name... fields) TheCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Name view, Name... fields) TheCREATE VIEW IF NOT EXISTS
statement.@NotNull SelectJoinStep<R>
SelectJoinStep.crossApply
(Name name) CROSS APPLY
a table to this table.Table.crossApply
(Name name) CROSS APPLY
a table to this table.@NotNull SelectJoinStep<R>
Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(Name)
CROSS JOIN
a table to this table.@NotNull BigInteger
Convenience method to fetch the CURRVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.@Nullable DataType<?>
Get the field data type for a given qualified field name, ornull
if no field is known to this type by this name.@NotNull AlterTableDropStep
Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
AlterTableStep.dropColumn
(Name field) Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
AlterTableStep.dropColumnIfExists
(Name field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement.@NotNull AlterTableDropStep
AlterTableStep.dropColumns
(Name... fields) Add anDROP COLUMN
clause to theALTER TABLE
statement.@NotNull AlterDomainDropConstraintCascadeStep
AlterDomainStep.dropConstraint
(Name dropConstraint) Add theDROP CONSTRAINT
clause to theALTER DOMAIN
statement.@NotNull AlterTableDropStep
AlterTableStep.dropConstraint
(Name constraint) Add aDROP CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterDomainDropConstraintCascadeStep
AlterDomainStep.dropConstraintIfExists
(Name dropConstraint) Add theDROP CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement.@NotNull AlterTableDropStep
AlterTableStep.dropConstraintIfExists
(Name constraint) Add aDROP CONSTRAINT IF EXISTS
clause to theALTER TABLE
statement.@NotNull DropDatabaseFinalStep
DSLContext.dropDatabase
(Name database) TheDROP DATABASE
statement.@NotNull DropDatabaseFinalStep
DSLContext.dropDatabaseIfExists
(Name database) TheDROP DATABASE IF EXISTS
statement.@NotNull DropDomainCascadeStep
DSLContext.dropDomain
(Name domain) TheDROP DOMAIN
statement.@NotNull DropDomainCascadeStep
DSLContext.dropDomainIfExists
(Name domain) TheDROP DOMAIN IF EXISTS
statement.@NotNull AlterTableDropStep
AlterTableStep.dropForeignKey
(Name constraint) Add aDROP FOREIGN KEY
clause to theALTER TABLE
statement.@NotNull DDLQuery
DSLContext.dropFunction
(Name function) TheDROP FUNCTION
statement.@NotNull DDLQuery
DSLContext.dropFunctionIfExists
(Name function) TheDROP FUNCTION IF EXISTS
statement.@NotNull AlterTableDropStep
AlterTableStep.dropIfExists
(Name field) Add anDROP COLUMN IF EXISTS
clause to theALTER TABLE
statement.@NotNull DropIndexOnStep
TheDROP INDEX
statement.@NotNull DropIndexOnStep
DSLContext.dropIndexIfExists
(Name index) TheDROP INDEX IF EXISTS
statement.@NotNull DropViewFinalStep
DSLContext.dropMaterializedView
(Name view) TheDROP MATERIALIZED VIEW
statement.@NotNull DropViewFinalStep
DSLContext.dropMaterializedViewIfExists
(Name view) TheDROP MATERIALIZED VIEW IF EXISTS
statement.@NotNull AlterTableDropStep
AlterTableStep.dropPrimaryKey
(Name constraint) Add aDROP PRIMARY KEY
clause to theALTER TABLE
statement.@NotNull DDLQuery
DSLContext.dropProcedure
(Name procedure) TheDROP PROCEDURE
statement.@NotNull DDLQuery
DSLContext.dropProcedureIfExists
(Name procedure) TheDROP PROCEDURE IF EXISTS
statement.@NotNull DropSchemaStep
DSLContext.dropSchema
(Name schema) TheDROP SCHEMA
statement.@NotNull DropSchemaStep
DSLContext.dropSchemaIfExists
(Name schema) TheDROP SCHEMA IF EXISTS
statement.@NotNull DropSequenceFinalStep
DSLContext.dropSequence
(Name sequence) TheDROP SEQUENCE
statement.@NotNull DropSequenceFinalStep
DSLContext.dropSequenceIfExists
(Name sequence) TheDROP SEQUENCE IF EXISTS
statement.@NotNull DropTableStep
TheDROP TABLE
statement.@NotNull DropTableStep
DSLContext.dropTableIfExists
(Name table) TheDROP TABLE IF EXISTS
statement.@NotNull DropTableStep
DSLContext.dropTemporaryTable
(Name table) TheDROP TEMPORARY TABLE
statement.@NotNull DropTableStep
DSLContext.dropTemporaryTableIfExists
(Name table) TheDROP TEMPORARY TABLE IF EXISTS
statement.@NotNull DropTriggerOnStep
DSLContext.dropTrigger
(Name trigger) TheDROP TRIGGER
statement.@NotNull DropTriggerOnStep
DSLContext.dropTriggerIfExists
(Name trigger) TheDROP TRIGGER IF EXISTS
statement.@NotNull DropTypeStep
TheDROP TYPE
statement.@NotNull DropTypeStep
TheDROP TYPE
statement.@NotNull DropTypeStep
DSLContext.dropTypeIfExists
(Name types) TheDROP TYPE IF EXISTS
statement.@NotNull DropTypeStep
DSLContext.dropTypeIfExists
(Name... types) TheDROP TYPE IF EXISTS
statement.@NotNull AlterTableDropStep
AlterTableStep.dropUnique
(Name constraint) Add aDROP UNIQUE
clause to theALTER TABLE
statement.@NotNull DropViewFinalStep
TheDROP VIEW
statement.@NotNull DropViewFinalStep
DSLContext.dropViewIfExists
(Name view) TheDROP VIEW IF EXISTS
statement.boolean
Name.equalsIgnoreCase
(Name other) Compare this name with another one ignoring case.@NotNull Asterisk
The asterisk (*
) to be used inSELECT
clauses.@NotNull QualifiedAsterisk
The qualified asterisk (t.* EXCEPT (fields)
) expression to be used inSELECT
clauses.@NotNull List<?>
Execute the query and return all values for a field name from the generated result, usingFields.field(Name)
for lookup.<U> @NotNull List<U>
Execute the query and return all values for a field name from the generated result, usingFields.field(Name)
for lookup.<U> @NotNull List<U>
Execute the query and return all values for a field name from the generated result, usingFields.field(Name)
for lookup.@Nullable Object
Execute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)
for lookup.<U> U
Execute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)
for lookup.<U> U
Execute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)
for lookup.@Nullable Object @NotNull []
ResultQuery.fetchArray
(Name fieldName) Execute the query and return all values for a field name from the generated result, usingFields.field(Name)
for lookup.<U> U @NotNull []
ResultQuery.fetchArray
(Name fieldName, Class<? extends U> type) Execute the query and return all values for a field name from the generated result, usingFields.field(Name)
for lookup.<U> U @NotNull []
ResultQuery.fetchArray
(Name fieldName, Converter<?, ? extends U> converter) Execute the query and return all values for a field name from the generated result, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name keyFieldName) Execute the query and return aMap
with one of the result's columns as key and a list of corresponding records as value, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name[] keyFieldNames) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name[] keyFieldNames, Class<? extends E> type) Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name[] keyFieldNames, Name[] valueFieldNames) Execute the query and return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name keyFieldName, Class<? extends E> type) Return aMap
with results grouped by the given key and mapped into the given entity type, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name keyFieldName, Name valueFieldName) Execute the query and return aMap
with one of the result's columns as key and another one of the result's columns as value, usingFields.field(Name)
for lookup.ResultQuery.fetchGroups
(Name keyFieldName, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given key and mapped by the given mapper, usingFields.field(Name)
for lookup.Execute the query and return aMap
with one of the result's columns as key and the corresponding records as value, usingFields.field(Name)
for lookup.Execute the query and return aMap
with keys as a map key and the corresponding record as value, usingFields.field(Name)
for lookup.Execute the query and return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)
for lookup.Execute the query and return aMap
with keys as a map key and the corresponding record as value, usingFields.field(Name)
for lookup.ResultQuery.fetchMap
(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given keys and mapped by the given mapper, usingFields.field(Name)
for lookup.<E> @NotNull Map<?,
E> Execute the query and return aMap
with results grouped by the given key and mapped into the given entity type, usingFields.field(Name)
for lookup.@NotNull Map<?,
?> Execute the query and return aMap
with one of the result's columns as key and another one of the result's columns as value, usingFields.field(Name)
for lookup.<E> @NotNull Map<?,
E> ResultQuery.fetchMap
(Name keyFieldName, RecordMapper<? super R, E> mapper) Execute the query and return aMap
with results grouped by the given key and mapped by the given mapper, usingFields.field(Name)
for lookup.@Nullable Object
Execute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)
for lookup.<U> U
Execute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)
for lookup.<U> U
Execute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)
for lookup.@NotNull Optional<?>
ResultQuery.fetchOptional
(Name fieldName) Execute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)
for lookup.<U> @NotNull Optional<U>
ResultQuery.fetchOptional
(Name fieldName, Class<? extends U> type) Execute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)
for lookup.<U> @NotNull Optional<U>
ResultQuery.fetchOptional
(Name fieldName, Converter<?, ? extends U> converter) Execute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)
for lookup.@NotNull Set<?>
Execute the query and return all values for a field name from the generated result, usingFields.field(Name)
for lookup.<U> @NotNull Set<U>
Execute the query and return all values for a field name from the generated result, usingFields.field(Name)
for lookup.<U> @NotNull Set<U>
Execute the query and return all values for a field name from the generated result, usingFields.field(Name)
for lookup.@Nullable Object
ResultQuery.fetchSingle
(Name fieldName) Execute the query and return exactly one resulting value for a field name from the generated result, usingFields.field(Name)
for lookup.<U> U
ResultQuery.fetchSingle
(Name fieldName, Class<? extends U> type) Execute the query and return exactly one resulting value for a field name from the generated result, usingFields.field(Name)
for lookup.<U> U
ResultQuery.fetchSingle
(Name fieldName, Converter<?, ? extends U> converter) Execute the query and return exactly one resulting value for a field name from the generated result, usingFields.field(Name)
for lookup.@Nullable Field<?>
Get a field known to this type by qualified name, ornull
if no field is known to this type by this name.<T> @Nullable Field<T>
Get a field known to this type by qualified name coerced totype
usingField.coerce(Class)
, ornull
if no field is known to this type by this name.<T> @Nullable Field<T>
Get a field known to this type by qualified name coerced todataType
usingField.coerce(DataType)
, ornull
if no field is known to this type by this name.@Nullable Field<?> @NotNull []
Get all fields known to this type, filtering by some qualified field names.@NotNull DerivedColumnList1
Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList
Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList2
Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList3
Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList4
Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList5
Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList6
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList7
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList8
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList9
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList10
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList11
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList12
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList13
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList14
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList15
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList16
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList17
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList18
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList19
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18, Name fieldName19) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList20
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18, Name fieldName19, Name fieldName20) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList21
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18, Name fieldName19, Name fieldName20, Name fieldName21) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull DerivedColumnList22
Name.fields
(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18, Name fieldName19, Name fieldName20, Name fieldName21, Name fieldName22) Add a list of fields to this name to make this name aDerivedColumnList
.@NotNull ConstraintForeignKeyReferencesStep1<?>
ConstraintTypeStep.foreignKey
(Name field1) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStepN
ConstraintTypeStep.foreignKey
(Name... fields) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep2<?,
?> ConstraintTypeStep.foreignKey
(Name field1, Name field2) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep3<?,
?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep4<?,
?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep5<?,
?, ?, ?, ?> Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep6<?,
?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep7<?,
?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep8<?,
?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep9<?,
?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep10<?,
?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep11<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep12<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep13<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep14<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep15<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep16<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep17<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep18<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep19<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep20<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep21<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20, Name field21) Add aFOREIGN KEY
clause to theCONSTRAINT
.@NotNull ConstraintForeignKeyReferencesStep22<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20, Name field21, Name field22) Add aFOREIGN KEY
clause to theCONSTRAINT
.void
Load data into this record from a source, providing some field names, usingFields.field(Name)
for lookup.@NotNull SelectJoinStep<R>
Add aFROM
clause to the query.@NotNull UpdateWhereStep<R>
Add aFROM
clause to the query.void
Load data from an array into this record, providing some fields names, usingFields.field(Name)
for lookup.void
Load data from a map into this record, providing some field names, usingFields.field(Name)
for lookup.@NotNull SelectOnStep<R>
Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(Name)
.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
FULL OUTER JOIN
a table to this table.@NotNull SelectOnStep<R>
SelectJoinStep.fullOuterJoin
(Name name) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(Name)
@NotNull TablePartitionByStep<Record>
Table.fullOuterJoin
(Name name) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.fullOuterJoin
(Name name) FULL OUTER JOIN
a table to this table.@Nullable Object
Get a value from this Record, providing a field name, usingFields.field(Name)
for lookup.<U> U
Get a converted value from this Record, providing a field name, usingFields.field(Name)
for lookup.<U> U
Get a converted value from this Record, providing a field name, usingFields.field(Name)
for lookup.@NotNull Catalog
Meta.getCatalog
(Name name) Get a catalog object by name from the underlying meta data source, ornull
if no such object exists.@Nullable Domain<?>
Get a domain by its qualified or unqualified name in this schema, ornull
if no such domain exists.Meta.getDomains
(Name name) Get all domain objects by name from the underlying meta data source.@NotNull List<ForeignKey<?,
?>> Meta.getForeignKeys
(Name name) Get all foreign keys from the underlying meta data source.@NotNull List<ForeignKey<?,
?>> Schema.getForeignKeys
(Name name) Get foreign keys by their qualified or unqualified name in this schema.Meta.getIndexes
(Name name) Get all indexes from the underlying meta data sources.Schema.getIndexes
(Name name) Get indexes by their qualified or unqualified name in this schema.Meta.getPrimaryKeys
(Name name) Get all primary keys from the underlying meta data source.Schema.getPrimaryKeys
(Name name) Get primary keys by their qualified or unqualified name in this schema.@Nullable Schema
Get a schema by its qualified or unqualified name in this catalog, ornull
if no such schema exists.Meta.getSchemas
(Name name) Get all schema objects by name from the underlying meta data source.@Nullable Sequence<?>
Schema.getSequence
(Name name) Get a sequence by its qualified or unqualified name in this schema, ornull
if no such sequence exists.Meta.getSequences
(Name name) Get all sequence objects by name from the underlying meta data source.@Nullable Table<?>
Get a table by its qualified or unqualified name in this schema, ornull
if no such table exists.Get all table objects by name from the underlying meta data source.@Nullable Trigger
Schema.getTrigger
(Name name) Get a trigger by its qualified or unqualified name in this schema, ornull
if no such trigger exists.Meta.getTriggers
(Name name) Get all trigger objects by name from the underlying meta data source.@Nullable UDT<?>
Get a UDT by its qualified or unqualified name in this schema, ornull
if no such UDT exists.Meta.getUniqueKeys
(Name name) Get all unique keys from the underlying meta data source.Schema.getUniqueKeys
(Name name) Get unique keys (including primary keys) by their qualified or unqualified name in this schema.Get a value from this Record, providing a field name, usingFields.field(Name)
for lookup.<T> T
Get a converted value from this Record, providing a field name, usingFields.field(Name)
for lookup.<U> U
Get a converted value from this Record, providing a field name, usingFields.field(Name)
for lookup.@NotNull List<?>
Convenience method to fetch all values for a given field.<U> @NotNull List<U>
Convenience method to fetch all values for a given field.<U> @NotNull List<U>
Convenience method to fetch all values for a given field.@NotNull CreateIndexWhereStep
Add theINCLUDE
clause to theCREATE INDEX
statement.int
Get a field's index from this type.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(Name)
.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull CloseableResultQuery<R>
Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0@NotNull ResultQuery<R>
Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0@Nullable Object @NotNull []
Return all values for a field name from the result, usingFields.field(Name)
for lookup.<U> U @NotNull []
Return all values for a field name from the result, usingFields.field(Name)
for lookup.<U> U @NotNull []
Return all values for a field name from the result, usingFields.field(Name)
for lookup.Result.intoGroups
(Name keyFieldName) Return aMap
with one of the result's columns as key and a list of corresponding records as value, usingFields.field(Name)
for lookup.Result.intoGroups
(Name[] keyFieldNames) Return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.Result.intoGroups
(Name[] keyFieldNames, Class<? extends E> type) Return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)
for lookup.Result.intoGroups
(Name[] keyFieldNames, Name[] valueFieldNames) Return aMap
with the result grouped by the given keys, usingFields.field(Name)
for lookup.Result.intoGroups
(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)
for lookup.Result.intoGroups
(Name keyFieldName, Class<? extends E> type) Return aMap
with results grouped by the given key and mapped into the given entity type, usingFields.field(Name)
for lookup.Result.intoGroups
(Name keyFieldName, Name valueFieldName) Return aMap
with one of the result's columns as key and another one of the result's columns as value, usingFields.field(Name)
for lookup.Result.intoGroups
(Name keyFieldName, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given key and mapped by the given mapper, usingFields.field(Name)
for lookup.Return aMap
with one of the result's columns as key and the corresponding records as value, usingFields.field(Name)
for lookup.Return aMap
with the given keys as a map key and the corresponding record as value, usingFields.field(Name)
for lookup.Return aMap
with results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)
for lookup.Return aMap
with the given keys as a map key and the corresponding record as value, usingFields.field(Name)
for lookup.Result.intoMap
(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given keys and mapped by the given mapper, usingFields.field(Name)
for lookup.<E> @NotNull Map<?,
E> Return aMap
with results grouped by the given key and mapped into the given entity type, usingFields.field(Name)
for lookup.@NotNull Map<?,
?> Return aMap
with one of the result's columns as key and another one of the result's columns as value, usingFields.field(Name)
for lookup.<E> @NotNull Map<?,
E> Result.intoMap
(Name keyFieldName, RecordMapper<? super R, E> mapper) Return aMap
with results grouped by the given key and mapped by the given mapper, usingFields.field(Name)
for lookup.@NotNull Set<?>
Return all values for a field name from the result, usingFields.field(Name)
for lookup.<U> @NotNull Set<U>
Return all values for a field name from the result, usingFields.field(Name)
for lookup.<U> @NotNull Set<U>
Return all values for a field name from the result, usingFields.field(Name)
for lookup.@NotNull SelectOnStep<R>
Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(Name)
.@NotNull TableOnStep<Record>
INNER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep<R>
Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(Name)
.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.leftOuterJoin
(Name name) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(Name)
@NotNull TablePartitionByStep<Record>
Table.leftOuterJoin
(Name name) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.leftOuterJoin
(Name name) LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.naturalFullOuterJoin
(Name name) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(Name)
Table.naturalFullOuterJoin
(Name name) NATURAL FULL OUTER JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.naturalJoin
(Name name) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(Name)
Table.naturalJoin
(Name name) NATURAL JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.naturalLeftOuterJoin
(Name name) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(Name)
Table.naturalLeftOuterJoin
(Name name) NATURAL LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinStep<R>
SelectJoinStep.naturalRightOuterJoin
(Name name) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(Name)
Table.naturalRightOuterJoin
(Name name) NATURAL RIGHT OUTER JOIN
a table to this table.@NotNull BigInteger
Convenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext
's underlying JDBCConnection
.@NotNull CreateTriggerEventOrStep
Add theOF
clause to theCREATE TRIGGER
statement.@NotNull AlterIndexStep
Add theON
clause to theALTER INDEX
statement.@NotNull CreateIndexIncludeStep
CreateIndexStep.on
(Name table, Collection<? extends Name> on) Add theON
clause to theCREATE INDEX
statement.@NotNull CreateIndexIncludeStep
Add theON
clause to theCREATE INDEX
statement.@NotNull CreateTriggerReferencingStep
Add theON
clause to theCREATE TRIGGER
statement.@NotNull DropIndexCascadeStep
Add theON
clause to theDROP INDEX
statement.@NotNull DDLQuery
Add theON
clause to theDROP TRIGGER
statement.@NotNull GrantToStep
Add theON
clause to theGRANT
statement.@NotNull RevokeFromStep
Add theON
clause to theREVOKE
statement.@NotNull InsertOnConflictDoUpdateStep<R>
InsertOnDuplicateStep.onConflictOnConstraint
(Name constraint) Add aON CONFLICT ON CONSTRAINT
clause to this INSERT statement.void
InsertQuery.onConflictOnConstraint
(Name constraint) Whether use aON CONFLICT
orON CONFLICT ON CONSTRAINT
clause in thisINSERT
statement.@Nullable Object
Get an original value from this record as fetched from the database, usingFields.field(Name)
for lookup.@NotNull SelectJoinStep<R>
SelectJoinStep.outerApply
(Name name) OUTER APPLY
a table to this table.Table.outerApply
(Name name) OUTER APPLY
a table to this table.@NotNull WindowFinalStep<T>
Turn this aggregate function into a window function referencing a window name.@NotNull ConstraintEnforcementStep
ConstraintTypeStep.primaryKey
(Name... fields) Create aPRIMARY KEY
constraint.@NotNull CreateTableElementListStep
CreateTableElementListStep.primaryKey
(Name... fields) Add thePRIMARY KEY
clause to theCREATE TABLE
statement.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep1.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep1.references
(Name table, Name field1) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep10.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep10.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep11.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep11.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep12.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep12.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep13.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep13.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep14.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep14.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep15.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep15.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep16.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep16.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep17.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep17.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep18.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep18.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep19.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep19.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep2.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep2.references
(Name table, Name field1, Name field2) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep20.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep20.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep21.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep21.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20, Name field21) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep22.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep22.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20, Name field21, Name field22) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep3.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep3.references
(Name table, Name field1, Name field2, Name field3) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep4.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep4.references
(Name table, Name field1, Name field2, Name field3, Name field4) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep5.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep5.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep6.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep6.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep7.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep7.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep8.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep8.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep9.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStep9.references
(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStepN.references
(Name table) Add aREFERENCES
clause to theCONSTRAINT
, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStepN.references
(Name table, Collection<? extends Name> fields) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStepN.references
(Name table, Name... fields) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull CreateTriggerReferencingStep
CreateTriggerReferencingStep.referencingNewAs
(Name referencingNewAs) Add theREFERENCING NEW AS
clause to theCREATE TRIGGER
statement.@NotNull CreateTriggerReferencingStep
CreateTriggerReferencingStep.referencingOldAs
(Name referencingOldAs) Add theREFERENCING OLD AS
clause to theCREATE TRIGGER
statement.@NotNull Query
DSLContext.releaseSavepoint
(Name name) TheRELEASE SAVEPOINT
statement.@NotNull AlterTableRenameColumnToStep
AlterTableStep.renameColumn
(Name oldName) Add aRENAME COLUMN
clause to theALTER TABLE
statement.@NotNull AlterDomainRenameConstraintStep
AlterDomainStep.renameConstraint
(Name renameConstraint) Add theRENAME CONSTRAINT
clause to theALTER DOMAIN
statement.@NotNull AlterTableRenameConstraintToStep
AlterTableStep.renameConstraint
(Name oldName) Add aRENAME CONSTRAINT
clause to theALTER TABLE
statement.@NotNull AlterDomainRenameConstraintStep
AlterDomainStep.renameConstraintIfExists
(Name renameConstraint) Add theRENAME CONSTRAINT IF EXISTS
clause to theALTER DOMAIN
statement.@NotNull AlterTableRenameIndexToStep
AlterTableStep.renameIndex
(Name oldName) Add aRENAME INDEX
clause to theALTER TABLE
statement.@NotNull AlterDatabaseFinalStep
Add theRENAME TO
clause to theALTER DATABASE
statement.@NotNull AlterDomainFinalStep
Add theRENAME TO
clause to theALTER DOMAIN
statement.@NotNull AlterIndexFinalStep
Add theRENAME TO
clause to theALTER INDEX
statement.@NotNull AlterSchemaFinalStep
Add theRENAME TO
clause to theALTER SCHEMA
statement.@NotNull AlterSequenceFinalStep
Add theRENAME TO
clause to theALTER SEQUENCE
statement.@NotNull AlterTableFinalStep
Add aRENAME TO
clause to theALTER TABLE
statement.@NotNull AlterTypeFinalStep
Add theRENAME TO
clause to theALTER TYPE
statement.@NotNull AlterViewFinalStep
Add theRENAME TO
clause to theALTER VIEW
statement.void
Reset a given value to itsRecord.original(Name)
value and itsRecord.changed(Name)
flag tofalse
, usingFields.field(Name)
for lookup.@NotNull SelectJoinPartitionByStep<R>
Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(Name)
.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
RIGHT OUTER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep<R>
SelectJoinStep.rightOuterJoin
(Name name) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(Name)
@NotNull TablePartitionByStep<Record>
Table.rightOuterJoin
(Name name) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep<Record>
TableOuterJoinStep.rightOuterJoin
(Name name) RIGHT OUTER JOIN
a table to this table.@NotNull Query
TheSAVEPOINT
statement.@NotNull SelectWhereStep<Record>
DSLContext.selectFrom
(Name table) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep<Record>
WithStep.selectFrom
(Name table) Create a new DSL select statement, projecting*
.@NotNull RowCountQuery
TheSET
statement.@NotNull RowCountQuery
DSLContext.setCatalog
(Name catalog) TheSET CATALOG
statement.@NotNull RowCountQuery
TheSET LOCAL
statement.@NotNull AlterTypeFinalStep
Add theSET SCHEMA
clause to theALTER TYPE
statement.@NotNull RowCountQuery
TheSET SCHEMA
statement.Sort this result by one of its contained fields, usingFields.field(Name)
for lookup.Result.sortAsc
(Name fieldName, Comparator<?> comparator) Sort this result by one of its contained fields using a comparator, usingFields.field(Name)
for lookup.Reverse-sort this result by one of its contained fields, usingFields.field(Name)
for lookup.Result.sortDesc
(Name fieldName, Comparator<?> comparator) Reverse-sort this result by one of its contained fields using a comparator, usingFields.field(Name)
for lookup.@NotNull SelectOnStep<R>
SelectJoinStep.straightJoin
(Name name) STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep<Record>
Table.straightJoin
(Name name) STRAIGHT_JOIN
a table to this table.@NotNull AlterDomainFinalStep
Add theTO
clause to theALTER DOMAIN
statement.@NotNull AlterTableFinalStep
Specify a new column name.@NotNull AlterTableFinalStep
Specify a new constraint name.@NotNull AlterTableFinalStep
Specify a new index name.@NotNull Query
RollbackToSavepointStep.toSavepoint
(Name toSavepoint) Add theTO SAVEPOINT
clause to theROLLBACK
statement.@NotNull TruncateIdentityStep<Record>
TheTRUNCATE
statement.@NotNull TruncateIdentityStep<Record>
TheTRUNCATE
statement.@NotNull TruncateIdentityStep<Record>
DSLContext.truncateTable
(Name table) TheTRUNCATE TABLE
statement.@NotNull TruncateIdentityStep<Record>
DSLContext.truncateTable
(Name... table) TheTRUNCATE TABLE
statement.@Nullable Class<?>
Get the field type for a given qualified field name, ornull
if no field is known to this type by this name.@NotNull ConstraintEnforcementStep
Create aUNIQUE
constraint.@NotNull CreateTableElementListStep
Add theUNIQUE
clause to theCREATE TABLE
statement.@NotNull DeleteWhereStep<R>
Add aUSING
clause to the query.@NotNull AlterTableFinalStep
AlterTableUsingIndexStep.usingIndex
(Name index) Add theUSING INDEX
clause to the statement.@NotNull WithAsStep
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep
DSLContext.with
(Name alias, Collection<? extends Name> fieldAliases) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep1
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep2
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep3
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep4
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep5
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep6
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep7
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep8
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep9
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep10
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep11
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep12
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep13
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep14
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep15
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep16
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep17
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep18
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep19
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep20
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep21
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep22
DSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21, Name fieldAlias22) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep
Add another common table expression to theWITH
clause.@NotNull WithAsStep
WithStep.with
(Name alias, Collection<? extends Name> fieldAliases) Add another common table expression to theWITH
clause.@NotNull WithAsStep1
Add another common table expression to theWITH
clause.@NotNull WithAsStep
Add another common table expression to theWITH
clause.@NotNull WithAsStep2
Add another common table expression to theWITH
clause.@NotNull WithAsStep3
Add another common table expression to theWITH
clause.@NotNull WithAsStep4
Add another common table expression to theWITH
clause.@NotNull WithAsStep5
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) Add another common table expression to theWITH
clause.@NotNull WithAsStep6
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) Add another common table expression to theWITH
clause.@NotNull WithAsStep7
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) Add another common table expression to theWITH
clause.@NotNull WithAsStep8
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8) Add another common table expression to theWITH
clause.@NotNull WithAsStep9
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9) Add another common table expression to theWITH
clause.@NotNull WithAsStep10
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10) Add another common table expression to theWITH
clause.@NotNull WithAsStep11
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11) Add another common table expression to theWITH
clause.@NotNull WithAsStep12
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12) Add another common table expression to theWITH
clause.@NotNull WithAsStep13
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13) Add another common table expression to theWITH
clause.@NotNull WithAsStep14
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14) Add another common table expression to theWITH
clause.@NotNull WithAsStep15
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15) Add another common table expression to theWITH
clause.@NotNull WithAsStep16
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16) Add another common table expression to theWITH
clause.@NotNull WithAsStep17
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17) Add another common table expression to theWITH
clause.@NotNull WithAsStep18
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18) Add another common table expression to theWITH
clause.@NotNull WithAsStep19
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19) Add another common table expression to theWITH
clause.@NotNull WithAsStep20
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20) Add another common table expression to theWITH
clause.@NotNull WithAsStep21
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21) Add another common table expression to theWITH
clause.@NotNull WithAsStep22
WithStep.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21, Name fieldAlias22) Add another common table expression to theWITH
clause.@NotNull WithAsStep
DSLContext.withRecursive
(Name alias) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep
DSLContext.withRecursive
(Name alias, Collection<? extends Name> fieldAliases) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep1
DSLContext.withRecursive
(Name alias, Name fieldAlias1) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep
DSLContext.withRecursive
(Name alias, Name... fieldAliases) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep2
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep3
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep4
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep5
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep6
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep7
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep8
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep9
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep10
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep11
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep12
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep13
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep14
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep15
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep16
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep17
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep18
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep19
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep20
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep21
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep22
DSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21, Name fieldAlias22) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.Modifier and TypeMethodDescriptionTable.as
(Name alias, Collection<? extends Name> fieldAliases) Create an alias for this table and its fields.Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.TableLike.asTable
(Name alias, Collection<? extends Name> fieldAliases) The underlying aliased table representation of this object.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createMaterializedViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createOrReplaceView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Name view, Collection<? extends Name> fields) TheCREATE VIEW
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE VIEW IF NOT EXISTS
statement.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateViewAsStep<Record>
DSLContext.createViewIfNotExists
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.@NotNull CreateIndexIncludeStep
CreateIndexStep.on
(Name table, Collection<? extends Name> on) Add theON
clause to theCREATE INDEX
statement.@NotNull ConstraintForeignKeyOnStep
ConstraintForeignKeyReferencesStepN.references
(Name table, Collection<? extends Name> fields) Add aREFERENCES
clause to theCONSTRAINT
, referencing a key by column names.@NotNull WithAsStep
DSLContext.with
(Name alias, Collection<? extends Name> fieldAliases) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.@NotNull WithAsStep
WithStep.with
(Name alias, Collection<? extends Name> fieldAliases) Add another common table expression to theWITH
clause.@NotNull WithAsStep
DSLContext.withRecursive
(Name alias, Collection<? extends Name> fieldAliases) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s. -
Uses of Name in org.jooq.impl
Modifier and TypeMethodDescription@Nullable Name
QOM.Aliasable.$alias()
The alias if any.@NotNull Name
QOM.FieldAlias.$alias()
@NotNull Name
QOM.TableAlias.$alias()
final Name
TableImpl.$alias()
@NotNull Name
QOM.XMLElement.$elementName()
@NotNull Name
QOM.CreateFunction.$function()
@NotNull Name
QOM.DropFunction.$function()
@NotNull Name
QOM.Label.$name()
@NotNull Name
QOM.ReleaseSavepoint.$name()
@NotNull Name
QOM.Savepoint.$name()
@NotNull Name
QOM.SetCommand.$name()
@NotNull Name
QOM.Call.$procedure()
@NotNull Name
QOM.CreateProcedure.$procedure()
@NotNull Name
QOM.DropProcedure.$procedure()
@Nullable Name
QOM.CreateTrigger.$referencingNewAs()
@Nullable Name
QOM.CreateTrigger.$referencingOldAs()
@Nullable Name
QOM.AlterType.$renameTo()
default @NotNull Name
QOM.XMLPi.$target()
@Nullable Name
QOM.Rollback.$toSavepoint()
@NotNull Name
QOM.AlterType.$type()
static final @NotNull Name
Internal.createPathAlias
(Table<?> path, ForeignKey<?, ?> childPath, InverseForeignKey<?, ?> parentPath) Factory method for path aliases.UDTImpl.getQualifiedName()
static @NotNull Name
Create a new SQL identifier using an unqualified name.static @NotNull Name
Create a new SQL identifier using a qualified name.static @NotNull Name
DSL.name
(Collection<String> qualifiedName) Create a new SQL identifier using a qualified name.static @NotNull Name
Create a new SQL identifier using a qualified name.static @NotNull Name
DSL.quotedName
(String unqualifiedName) Create a new SQL identifier using an unqualified, quoted name.static @NotNull Name
DSL.quotedName
(String... qualifiedName) Create a new SQL identifier using a qualified, quoted name.static @NotNull Name
DSL.quotedName
(Collection<String> qualifiedName) Create a new SQL identifier using a qualified, quoted name.static @NotNull Name
DSL.systemName
(String unqualifiedName) Create a new SQL identifier using an unqualified, quoted name.static @NotNull Name
DSL.systemName
(String... qualifiedName) Create a new SQL identifier using a qualified, quoted name.static @NotNull Name
DSL.systemName
(Collection<String> qualifiedName) Create a new SQL identifier using a qualified, system name.static @NotNull Name
DSL.unquotedName
(String unqualifiedName) Create a new SQL identifier using an unqualified, quoted name.static @NotNull Name
DSL.unquotedName
(String... qualifiedName) Create a new SQL identifier using a qualified, quoted name.static @NotNull Name
DSL.unquotedName
(Collection<String> qualifiedName) Create a new SQL identifier using a qualified, quoted name.Modifier and TypeMethodDescription@NotNull QOM.CreateFunction
@NotNull QOM.DropFunction
@NotNull QOM.ReleaseSavepoint
@NotNull QOM.Savepoint
@NotNull QOM.SetCommand
@NotNull QOM.Call
QOM.Call.$procedure
(Name procedure) @NotNull QOM.CreateProcedure
QOM.CreateProcedure.$procedure
(Name procedure) @NotNull QOM.DropProcedure
QOM.DropProcedure.$procedure
(Name procedure) @NotNull QOM.CreateTrigger
QOM.CreateTrigger.$referencingNewAs
(Name referencingNewAs) @NotNull QOM.CreateTrigger
QOM.CreateTrigger.$referencingOldAs
(Name referencingOldAs) @NotNull QOM.AlterType
default @NotNull QOM.XMLPi
@NotNull QOM.Rollback
QOM.Rollback.$toSavepoint
(Name toSavepoint) @NotNull QOM.AlterType
static <T> @NotNull AggregateFunction<T>
aggregate()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction<T>
aggregate()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction<T>
DSL.aggregateDistinct
(Name name, Class<T> type, Field<?>... arguments) aggregateDistinct()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull AggregateFunction<T>
DSL.aggregateDistinct
(Name name, DataType<T> type, Field<?>... arguments) aggregateDistinct()
can be used to access native or user-defined aggregate functions that are not yet or insufficiently supported by jOOQ.DefaultDSLContext.alterDatabase
(Name database) static AlterDatabaseStep
DSL.alterDatabase
(Name database) TheALTER DATABASE
statement.DefaultDSLContext.alterDatabaseIfExists
(Name database) static AlterDatabaseStep
DSL.alterDatabaseIfExists
(Name database) TheALTER DATABASE IF EXISTS
statement.<T> AlterDomainStep<T>
DefaultDSLContext.alterDomain
(Name domain) static <T> AlterDomainStep<T>
DSL.alterDomain
(Name domain) TheALTER DOMAIN
statement.<T> AlterDomainStep<T>
DefaultDSLContext.alterDomainIfExists
(Name domain) static <T> AlterDomainStep<T>
DSL.alterDomainIfExists
(Name domain) TheALTER DOMAIN IF EXISTS
statement.DefaultDSLContext.alterIndex
(Name index) static AlterIndexOnStep
DSL.alterIndex
(Name index) TheALTER INDEX
statement.DefaultDSLContext.alterIndexIfExists
(Name index) static AlterIndexOnStep
DSL.alterIndexIfExists
(Name index) TheALTER INDEX IF EXISTS
statement.DefaultDSLContext.alterMaterializedView
(Name view) static AlterViewStep
DSL.alterMaterializedView
(Name view) TheALTER MATERIALIZED VIEW
statement.DefaultDSLContext.alterMaterializedViewIfExists
(Name view) static AlterViewStep
DSL.alterMaterializedViewIfExists
(Name view) TheALTER MATERIALIZED VIEW IF EXISTS
statement.DefaultDSLContext.alterSchema
(Name schema) static AlterSchemaStep
DSL.alterSchema
(Name schema) TheALTER SCHEMA
statement.DefaultDSLContext.alterSchemaIfExists
(Name schema) static AlterSchemaStep
DSL.alterSchemaIfExists
(Name schema) TheALTER SCHEMA IF EXISTS
statement.DefaultDSLContext.alterSequence
(Name sequence) static AlterSequenceStep<Number>
DSL.alterSequence
(Name sequence) TheALTER SEQUENCE
statement.DefaultDSLContext.alterSequenceIfExists
(Name sequence) static AlterSequenceStep<Number>
DSL.alterSequenceIfExists
(Name sequence) TheALTER SEQUENCE IF EXISTS
statement.DefaultDSLContext.alterTable
(Name table) static @NotNull AlterTableStep
DSL.alterTable
(Name table) Create a new DSLALTER TABLE
statement.DefaultDSLContext.alterTableIfExists
(Name table) static @NotNull AlterTableStep
DSL.alterTableIfExists
(Name table) Create a new DSLALTER TABLE
statement.static AlterTypeStep
TheALTER TYPE
statement.DefaultDSLContext.alterTypeIfExists
(Name type) static AlterTypeStep
DSL.alterTypeIfExists
(Name type) TheALTER TYPE IF EXISTS
statement.static AlterViewStep
TheALTER VIEW
statement.DefaultDSLContext.alterViewIfExists
(Name view) static AlterViewStep
DSL.alterViewIfExists
(Name view) TheALTER VIEW IF EXISTS
statement.Subclasses may override this method to provide custom aliasing implementationsSubclasses may override this method to provide custom aliasing implementationsstatic CallArgsStep
TheCALL
statement.static @NotNull Catalog
Create a qualified catalog, given its catalog name.static @NotNull CharacterSet
DSL.characterSet
(Name characterSet) Create a character set by its qualified name.static @NotNull Collation
Create a collation by its qualified name.DefaultDSLContext.commentOnColumn
(Name field) static CommentOnIsStep
DSL.commentOnColumn
(Name field) TheCOMMENT ON COLUMN
statement.DefaultDSLContext.commentOnMaterializedView
(Name view) static CommentOnIsStep
DSL.commentOnMaterializedView
(Name view) TheCOMMENT ON MATERIALIZED VIEW
statement.DefaultDSLContext.commentOnTable
(Name table) static CommentOnIsStep
DSL.commentOnTable
(Name table) TheCOMMENT ON TABLE
statement.DefaultDSLContext.commentOnView
(Name view) static CommentOnIsStep
DSL.commentOnView
(Name view) TheCOMMENT ON VIEW
statement.static @NotNull ConstraintTypeStep
DSL.constraint
(Name name) Create aCONSTRAINT
specification.Internal.createCheck
(Table<R> table, Name name, String condition) Factory method for check constraints.Internal.createCheck
(Table<R> table, Name name, String condition, boolean enforced) Factory method for check constraints.DefaultDSLContext.createDatabase
(Name database) static CreateDatabaseFinalStep
DSL.createDatabase
(Name database) TheCREATE DATABASE
statement.DefaultDSLContext.createDatabaseIfNotExists
(Name database) static CreateDatabaseFinalStep
DSL.createDatabaseIfNotExists
(Name database) TheCREATE DATABASE IF NOT EXISTS
statement.DefaultDSLContext.createDomain
(Name domain) static CreateDomainAsStep
DSL.createDomain
(Name domain) TheCREATE DOMAIN
statement.static final <T,
U> @NotNull Domain<U> Internal.createDomain
(Schema schema, Name name, DataType<T> type, Binding<T, U> binding, Check<?>... checks) Factory method for domain specifications.static final <T> @NotNull Domain<T>
Internal.createDomain
(Schema schema, Name name, DataType<T> type, Check<?>... checks) Factory method for domain specifications.static final <T,
U> @NotNull Domain<U> Internal.createDomain
(Schema schema, Name name, DataType<T> type, Converter<T, U> converter, Check<?>... checks) Factory method for domain specifications.static final <T,
X, U> @NotNull Domain<U> Internal.createDomain
(Schema schema, Name name, DataType<T> type, Converter<X, U> converter, Binding<T, X> binding, Check<?>... checks) Factory method for domain specifications.DefaultDSLContext.createDomainIfNotExists
(Name domain) static CreateDomainAsStep
DSL.createDomainIfNotExists
(Name domain) TheCREATE DOMAIN IF NOT EXISTS
statement.static final <R extends Record,
E extends EmbeddableRecord<E>>
@NotNull TableField<R,E> Internal.createEmbeddable
(Name name, Class<E> recordType, boolean replacesFields, Table<R> table, TableField<R, ?>... fields) Factory method for embeddable types.static final <R extends Record,
E extends EmbeddableRecord<E>>
@NotNull TableField<R,E> Internal.createEmbeddable
(Name name, Class<E> recordType, Table<R> table, TableField<R, ?>... fields) Factory method for embeddable types.UDTImpl.createField
(Name name, DataType<T> type, UDT<R> udt) Subclasses may call this method to createUDTField
objects that are linked to this table.UDTImpl.createField
(Name name, DataType<T> type, UDT<R> udt, String comment) Subclasses may call this method to createUDTField
objects that are linked to this table.Subclasses may call this method to createUDTField
objects that are linked to this table.UDTImpl.createField
(Name name, DataType<T> type, UDT<R> udt, String comment, Converter<T, U> converter) Subclasses may call this method to createUDTField
objects that are linked to this table.UDTImpl.createField
(Name name, DataType<T> type, UDT<R> udt, String comment, Converter<X, U> converter, Binding<T, X> binding) Subclasses may call this method to createUDTField
objects that are linked to this table.static final <R extends Record,
U extends Record>
@NotNull ForeignKey<R,U> Internal.createForeignKey
(Table<R> table, Name name, TableField<R, ?>[] fkFields, UniqueKey<U> uk, TableField<U, ?>[] ukFields, boolean enforced) Factory method for foreign keys.static final <R extends Record,
U extends Record, ER extends EmbeddableRecord<ER>>
@NotNull ForeignKey<R,U> Internal.createForeignKey
(Table<R> table, Name name, TableField<R, ER> fkEmbeddableField, UniqueKey<U> uk, TableField<U, ER> ukEmbeddableField, boolean enforced) Factory method for foreign keys.DefaultDSLContext.createFunction
(Name function) static CreateFunctionParametersStep
DSL.createFunction
(Name function) TheCREATE FUNCTION
statement.DefaultDSLContext.createGlobalTemporaryTable
(Name table) static CreateTableElementListStep
DSL.createGlobalTemporaryTable
(Name table) TheCREATE GLOBAL TEMPORARY TABLE
statement.DefaultDSLContext.createGlobalTemporaryTableIfNotExists
(Name table) static CreateTableElementListStep
DSL.createGlobalTemporaryTableIfNotExists
(Name table) TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTS
statement.DefaultDSLContext.createIndex
(Name index) static CreateIndexStep
DSL.createIndex
(Name index) TheCREATE INDEX
statement.static final @NotNull Index
Internal.createIndex
(Name name, Table<?> table, OrderField<?>[] sortFields, boolean unique) Factory method for indexes.DefaultDSLContext.createIndexIfNotExists
(Name index) static CreateIndexStep
DSL.createIndexIfNotExists
(Name index) TheCREATE INDEX IF NOT EXISTS
statement.DefaultDSLContext.createMaterializedView
(Name view, Collection<? extends Name> fields) DefaultDSLContext.createMaterializedView
(Name view, Name... fields) static CreateViewAsStep<Record>
DSL.createMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW
statement.static CreateViewAsStep<Record>
DSL.createMaterializedView
(Name view, Name... fields) TheCREATE MATERIALIZED VIEW
statement.DefaultDSLContext.createMaterializedViewIfNotExists
(Name view, Collection<? extends Name> fields) DefaultDSLContext.createMaterializedViewIfNotExists
(Name view, Name... fields) static CreateViewAsStep<Record>
DSL.createMaterializedViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.static CreateViewAsStep<Record>
DSL.createMaterializedViewIfNotExists
(Name view, Name... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.DefaultDSLContext.createOrReplaceFunction
(Name function) static CreateFunctionParametersStep
DSL.createOrReplaceFunction
(Name function) TheCREATE OR REPLACE FUNCTION
statement.DefaultDSLContext.createOrReplaceMaterializedView
(Name view, Collection<? extends Name> fields) DefaultDSLContext.createOrReplaceMaterializedView
(Name view, Name... fields) static CreateViewAsStep<Record>
DSL.createOrReplaceMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.static CreateViewAsStep<Record>
DSL.createOrReplaceMaterializedView
(Name view, Name... fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.DefaultDSLContext.createOrReplaceProcedure
(Name procedure) DSL.createOrReplaceProcedure
(Name procedure) TheCREATE OR REPLACE PROCEDURE
statement.DefaultDSLContext.createOrReplaceTrigger
(Name trigger) static CreateTriggerEventStep
DSL.createOrReplaceTrigger
(Name trigger) TheCREATE OR REPLACE TRIGGER
statement.DefaultDSLContext.createOrReplaceView
(Name view, Collection<? extends Name> fields) DefaultDSLContext.createOrReplaceView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) DefaultDSLContext.createOrReplaceView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) DefaultDSLContext.createOrReplaceView
(Name view, Name... fields) static CreateViewAsStep<Record>
DSL.createOrReplaceView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE VIEW
statement.static @NotNull CreateViewAsStep<Record>
DSL.createOrReplaceView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep<Record>
DSL.createOrReplaceView
(Name view, Name... fields) TheCREATE OR REPLACE VIEW
statement.DefaultDSLContext.createProcedure
(Name procedure) DSL.createProcedure
(Name procedure) TheCREATE PROCEDURE
statement.DefaultDSLContext.createSchema
(Name schema) static CreateSchemaFinalStep
DSL.createSchema
(Name schema) TheCREATE SCHEMA
statement.DefaultDSLContext.createSchemaIfNotExists
(Name schema) static CreateSchemaFinalStep
DSL.createSchemaIfNotExists
(Name schema) TheCREATE SCHEMA IF NOT EXISTS
statement.DefaultDSLContext.createSequence
(Name sequence) static CreateSequenceFlagsStep
DSL.createSequence
(Name sequence) TheCREATE SEQUENCE
statement.DefaultDSLContext.createSequenceIfNotExists
(Name sequence) static CreateSequenceFlagsStep
DSL.createSequenceIfNotExists
(Name sequence) TheCREATE SEQUENCE IF NOT EXISTS
statement.DefaultDSLContext.createTable
(Name table) static CreateTableElementListStep
DSL.createTable
(Name table) TheCREATE TABLE
statement.DefaultDSLContext.createTableIfNotExists
(Name table) static CreateTableElementListStep
DSL.createTableIfNotExists
(Name table) TheCREATE TABLE IF NOT EXISTS
statement.DefaultDSLContext.createTemporaryTable
(Name table) static CreateTableElementListStep
DSL.createTemporaryTable
(Name table) TheCREATE TEMPORARY TABLE
statement.DefaultDSLContext.createTemporaryTableIfNotExists
(Name table) static CreateTableElementListStep
DSL.createTemporaryTableIfNotExists
(Name table) TheCREATE TEMPORARY TABLE IF NOT EXISTS
statement.DefaultDSLContext.createTrigger
(Name trigger) static CreateTriggerEventStep
DSL.createTrigger
(Name trigger) TheCREATE TRIGGER
statement.static final @NotNull Trigger
Internal.createTrigger
(Schema schema, Table<?> table, List<Field<?>> fields, Name name, Comment comment, TriggerTime time, Set<TriggerEvent> events, TriggerExecution execution, Condition when, int actionOrder, Statement action) Factory method for trigger specifications.DefaultDSLContext.createType
(Name type) static CreateTypeStep
DSL.createType
(Name type) TheCREATE TYPE
statement.DefaultDSLContext.createTypeIfNotExists
(Name type) static CreateTypeStep
DSL.createTypeIfNotExists
(Name type) TheCREATE TYPE IF NOT EXISTS
statement.static final <T,
P extends UDTField<?, T>>
PInternal.createUDTPathField
(Name name, DataType<T> type, UDTPathField<?, ?, ?> qualifier, Class<P> returnType) static final <T,
P extends UDTField<?, T>>
PInternal.createUDTPathField
(Name name, DataType<T> type, UDTPathField<?, ?, ?> qualifier, String comment, Class<P> returnType) static final <T,
U, P extends UDTField<?, U>>
PInternal.createUDTPathField
(Name name, DataType<T> type, UDTPathField<?, ?, ?> qualifier, String comment, Class<P> returnType, Binding<T, U> binding) static final <T,
U, P extends UDTField<?, U>>
PInternal.createUDTPathField
(Name name, DataType<T> type, UDTPathField<?, ?, ?> qualifier, String comment, Class<P> returnType, Converter<T, U> converter) static final <T,
X, U, P extends UDTField<?, U>>
PInternal.createUDTPathField
(Name name, DataType<T> type, UDTPathField<?, ?, ?> qualifier, String comment, Class<P> returnType, Converter<X, U> converter, Binding<T, X> binding) static final <R extends Record,
T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, Table<R> table, Class<P> returnType) static final <R extends Record,
T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, Table<R> table, String comment, Class<P> returnType) static final <R extends Record,
T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, Table<R> table, String comment, Class<P> returnType, Binding<T, U> binding) static final <R extends Record,
T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, Table<R> table, String comment, Class<P> returnType, Converter<T, U> converter) static final <R extends Record,
T, X, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, Table<R> table, String comment, Class<P> returnType, Converter<X, U> converter, Binding<T, X> binding) static final <R extends Record,
TR extends Table<R>, T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, TR table, String comment, Class<P> returnType, Binding<T, U> binding, Generator<R, TR, U> generator) static final <R extends Record,
TR extends Table<R>, T, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, TR table, String comment, Class<P> returnType, Converter<T, U> converter, Generator<R, TR, U> generator) static final <R extends Record,
TR extends Table<R>, T, X, U, P extends UDTPathTableField<R, ?, U>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, TR table, String comment, Class<P> returnType, Converter<X, U> converter, Binding<T, X> binding, Generator<R, TR, U> generator) static final <R extends Record,
TR extends Table<R>, T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField
(Name name, DataType<T> type, TR table, String comment, Class<P> returnType, Generator<R, TR, T> generator) DefaultDSLContext.createUniqueIndex
(Name index) static CreateIndexStep
DSL.createUniqueIndex
(Name index) TheCREATE UNIQUE INDEX
statement.DefaultDSLContext.createUniqueIndexIfNotExists
(Name index) static CreateIndexStep
DSL.createUniqueIndexIfNotExists
(Name index) TheCREATE UNIQUE INDEX IF NOT EXISTS
statement.Internal.createUniqueKey
(Table<R> table, Name name, TableField<R, ?>... fields) Factory method for unique keys.Internal.createUniqueKey
(Table<R> table, Name name, TableField<R, ?>[] fields, boolean enforced) Factory method for unique keys.static final <R extends Record,
ER extends EmbeddableRecord<ER>>
@NotNull UniqueKey<R>Internal.createUniqueKey
(Table<R> table, Name name, TableField<R, ER> embeddableField, boolean enforced) Factory method for unique keys.DefaultDSLContext.createView
(Name view, Collection<? extends Name> fields) DefaultDSLContext.createView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) DefaultDSLContext.createView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) DefaultDSLContext.createView
(Name view, Name... fields) static CreateViewAsStep<Record>
DSL.createView
(Name view, Collection<? extends Name> fields) TheCREATE VIEW
statement.static @NotNull CreateViewAsStep<Record>
DSL.createView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep<Record>
DSL.createView
(Name view, Name... fields) TheCREATE VIEW
statement.DefaultDSLContext.createViewIfNotExists
(Name view, Collection<? extends Name> fields) DefaultDSLContext.createViewIfNotExists
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) DefaultDSLContext.createViewIfNotExists
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) DefaultDSLContext.createViewIfNotExists
(Name view, Name... fields) static CreateViewAsStep<Record>
DSL.createViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE VIEW IF NOT EXISTS
statement.static @NotNull CreateViewAsStep<Record>
DSL.createViewIfNotExists
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.static CreateViewAsStep<Record>
DSL.createViewIfNotExists
(Name view, Name... fields) TheCREATE VIEW IF NOT EXISTS
statement.static @NotNull Domain<?>
Create aDOMAIN
reference.static <T> @NotNull Domain<T>
Create aDOMAIN
reference.static <T> @NotNull Domain<T>
Create aDOMAIN
reference.DefaultDSLContext.dropDatabase
(Name database) static DropDatabaseFinalStep
DSL.dropDatabase
(Name database) TheDROP DATABASE
statement.DefaultDSLContext.dropDatabaseIfExists
(Name database) static DropDatabaseFinalStep
DSL.dropDatabaseIfExists
(Name database) TheDROP DATABASE IF EXISTS
statement.DefaultDSLContext.dropDomain
(Name domain) static DropDomainCascadeStep
DSL.dropDomain
(Name domain) TheDROP DOMAIN
statement.DefaultDSLContext.dropDomainIfExists
(Name domain) static DropDomainCascadeStep
DSL.dropDomainIfExists
(Name domain) TheDROP DOMAIN IF EXISTS
statement.DefaultDSLContext.dropFunction
(Name function) static DDLQuery
DSL.dropFunction
(Name function) TheDROP FUNCTION
statement.DefaultDSLContext.dropFunctionIfExists
(Name function) static DDLQuery
DSL.dropFunctionIfExists
(Name function) TheDROP FUNCTION IF EXISTS
statement.static DropIndexOnStep
TheDROP INDEX
statement.DefaultDSLContext.dropIndexIfExists
(Name index) static DropIndexOnStep
DSL.dropIndexIfExists
(Name index) TheDROP INDEX IF EXISTS
statement.DefaultDSLContext.dropMaterializedView
(Name view) static DropViewFinalStep
DSL.dropMaterializedView
(Name view) TheDROP MATERIALIZED VIEW
statement.DefaultDSLContext.dropMaterializedViewIfExists
(Name view) static DropViewFinalStep
DSL.dropMaterializedViewIfExists
(Name view) TheDROP MATERIALIZED VIEW IF EXISTS
statement.DefaultDSLContext.dropProcedure
(Name procedure) static DDLQuery
DSL.dropProcedure
(Name procedure) TheDROP PROCEDURE
statement.DefaultDSLContext.dropProcedureIfExists
(Name procedure) static DDLQuery
DSL.dropProcedureIfExists
(Name procedure) TheDROP PROCEDURE IF EXISTS
statement.DefaultDSLContext.dropSchema
(Name schema) static DropSchemaStep
DSL.dropSchema
(Name schema) TheDROP SCHEMA
statement.DefaultDSLContext.dropSchemaIfExists
(Name schema) static DropSchemaStep
DSL.dropSchemaIfExists
(Name schema) TheDROP SCHEMA IF EXISTS
statement.DefaultDSLContext.dropSequence
(Name sequence) static DropSequenceFinalStep
DSL.dropSequence
(Name sequence) TheDROP SEQUENCE
statement.DefaultDSLContext.dropSequenceIfExists
(Name sequence) static DropSequenceFinalStep
DSL.dropSequenceIfExists
(Name sequence) TheDROP SEQUENCE IF EXISTS
statement.static DropTableStep
TheDROP TABLE
statement.DefaultDSLContext.dropTableIfExists
(Name table) static DropTableStep
DSL.dropTableIfExists
(Name table) TheDROP TABLE IF EXISTS
statement.DefaultDSLContext.dropTemporaryTable
(Name table) static DropTableStep
DSL.dropTemporaryTable
(Name table) TheDROP TEMPORARY TABLE
statement.DefaultDSLContext.dropTemporaryTableIfExists
(Name table) static DropTableStep
DSL.dropTemporaryTableIfExists
(Name table) TheDROP TEMPORARY TABLE IF EXISTS
statement.DefaultDSLContext.dropTrigger
(Name trigger) static DropTriggerOnStep
DSL.dropTrigger
(Name trigger) TheDROP TRIGGER
statement.DefaultDSLContext.dropTriggerIfExists
(Name trigger) static DropTriggerOnStep
DSL.dropTriggerIfExists
(Name trigger) TheDROP TRIGGER IF EXISTS
statement.static DropTypeStep
TheDROP TYPE
statement.static DropTypeStep
TheDROP TYPE
statement.DefaultDSLContext.dropTypeIfExists
(Name types) DefaultDSLContext.dropTypeIfExists
(Name... types) static DropTypeStep
DSL.dropTypeIfExists
(Name types) TheDROP TYPE IF EXISTS
statement.static DropTypeStep
DSL.dropTypeIfExists
(Name... types) TheDROP TYPE IF EXISTS
statement.static DropViewFinalStep
TheDROP VIEW
statement.DefaultDSLContext.dropViewIfExists
(Name view) static DropViewFinalStep
DSL.dropViewIfExists
(Name view) TheDROP VIEW IF EXISTS
statement.Create a qualified field, given its (qualified) field name.static <T> @NotNull Field<T>
Create a qualified field, given its (qualified) field name.static <T> @NotNull Field<T>
Create a qualified field, given its (qualified) field name.static <T> @NotNull Field<T>
Create a qualified field, given its (qualified) field name.Field<?>
<T> Field<T>
<T> Field<T>
static @NotNull ConstraintForeignKeyReferencesStep1<?>
DSL.foreignKey
(Name field1) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStepN
DSL.foreignKey
(Name... fields) Add aFOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep2<?,
?> DSL.foreignKey
(Name field1, Name field2) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep3<?,
?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep4<?,
?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep5<?,
?, ?, ?, ?> Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep6<?,
?, ?, ?, ?, ?> Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep7<?,
?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep8<?,
?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep9<?,
?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep10<?,
?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep11<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep12<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep13<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep14<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep15<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep16<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep17<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep18<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep19<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep20<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep21<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20, Name field21) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static @NotNull ConstraintForeignKeyReferencesStep22<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?> DSL.foreignKey
(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10, Name field11, Name field12, Name field13, Name field14, Name field15, Name field16, Name field17, Name field18, Name field19, Name field20, Name field21, Name field22) Add an unnamed (system named)FOREIGN KEY
clause to theCONSTRAINT
.static <T> @NotNull Field<T>
function()
can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.static <T> @NotNull Field<T>
function()
can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.final Domain<?>
final Domain<?>
final List<ForeignKey<?,
?>> LazySchema.getForeignKeys
(Name name) final List<ForeignKey<?,
?>> SchemaImpl.getForeignKeys
(Name name) LazySchema.getIndexes
(Name name) SchemaImpl.getIndexes
(Name name) LazySchema.getPrimaryKeys
(Name name) SchemaImpl.getPrimaryKeys
(Name name) final Schema
final Schema
final Sequence<?>
LazySchema.getSequence
(Name name) final Sequence<?>
SchemaImpl.getSequence
(Name name) final Table<?>
final Table<?>
final Trigger
LazySchema.getTrigger
(Name name) final Trigger
SchemaImpl.getTrigger
(Name name) final UDT<?>
final UDT<?>
LazySchema.getUniqueKeys
(Name name) SchemaImpl.getUniqueKeys
(Name name) static <T> @NotNull Parameter<T>
Create anIN
parameter.static @NotNull Index
Create a qualified index reference by name.static <T> @NotNull Parameter<T>
Create anIN OUT
parameter.static @NotNull Label
Create a label reference for use in procedural code.static @NotNull Link
Create a database link reference.static @NotNull Name
Create a new SQL identifier using a qualified name.static final <T> CustomField<T>
Create aCustomField
from a lambda expression.static <T> @NotNull Parameter<T>
Create anOUT
parameter.Create a namedPeriod
reference.static <T> @NotNull Period<T>
Create a namedPeriod
reference.static <T> @NotNull Period<T>
Create a namedPeriod
reference.static @NotNull ConstraintEnforcementStep
DSL.primaryKey
(Name... fields) Create an unnamed (system named)PRIMARY KEY
constraint.DefaultDSLContext.releaseSavepoint
(Name name) static Query
DSL.releaseSavepoint
(Name name) TheRELEASE SAVEPOINT
statement.static @NotNull Role
Create a new role reference.static Query
TheSAVEPOINT
statement.static @NotNull Schema
Create a qualified schema, given its schema name.DefaultDSLContext.selectFrom
(Name table) static @NotNull SelectWhereStep<Record>
DSL.selectFrom
(Name table) Create a new DSL select statement, projecting*
.static @NotNull Sequence<BigInteger>
Create a qualified sequence, given its sequence name.Create a qualified sequence, given its sequence name.Create a qualified sequence, given its sequence name.static RowCountQuery
TheSET
statement.DefaultDSLContext.setCatalog
(Name catalog) static RowCountQuery
DSL.setCatalog
(Name catalog) TheSET CATALOG
statement.static RowCountQuery
TheSET LOCAL
statement.static RowCountQuery
TheSET SCHEMA
statement.Create a qualified table, given its table name.Create a qualified table, given its table name.static @NotNull Trigger
Create a qualified trigger reference by name.static TruncateIdentityStep<Record>
TheTRUNCATE
statement.static TruncateIdentityStep<Record>
TheTRUNCATE
statement.DefaultDSLContext.truncateTable
(Name table) DefaultDSLContext.truncateTable
(Name... table) static TruncateIdentityStep<Record>
DSL.truncateTable
(Name table) TheTRUNCATE TABLE
statement.static TruncateIdentityStep<Record>
DSL.truncateTable
(Name... table) TheTRUNCATE TABLE
statement.static @NotNull Type<?>
Create a qualified type, given its type name.static <T> @NotNull Type<T>
Create a qualified type, given its type name.static @NotNull ConstraintEnforcementStep
Create an unnamed (system named)UNIQUE
constraint.static @NotNull User
Create a new user reference.static <T> @NotNull Variable<T>
Create a local variable reference for use in procedural code.static <T> @NotNull Variable<T>
A synonym forDSL.var(Name, DataType)
to be used in Scala and Groovy, wherevar
is a reserved keyword.DefaultDSLContext.with
(Name alias, Collection<? extends Name> fieldAliases) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21) DefaultDSLContext.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21, Name fieldAlias22) static @NotNull WithAsStep
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep
DSL.with
(Name alias, Collection<? extends Name> fieldAliases) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep1
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep2
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep3
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep4
Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep5
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep6
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep7
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep8
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep9
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep10
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep11
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep12
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep13
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep14
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep15
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep16
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep17
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep18
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep19
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep20
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep21
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep22
DSL.with
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21, Name fieldAlias22) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.DefaultDSLContext.withRecursive
(Name alias) DefaultDSLContext.withRecursive
(Name alias, Collection<? extends Name> fieldAliases) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1) DefaultDSLContext.withRecursive
(Name alias, Name... fieldAliases) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21) DefaultDSLContext.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21, Name fieldAlias22) static @NotNull WithAsStep
DSL.withRecursive
(Name alias) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep
DSL.withRecursive
(Name alias, Collection<? extends Name> fieldAliases) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep1
DSL.withRecursive
(Name alias, Name fieldAlias1) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep
DSL.withRecursive
(Name alias, Name... fieldAliases) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep2
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep3
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep4
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep5
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep6
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep7
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep8
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep9
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep10
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep11
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep12
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep13
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep14
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep15
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep16
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep17
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep18
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep19
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep20
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep21
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.static @NotNull WithAsStep22
DSL.withRecursive
(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10, Name fieldAlias11, Name fieldAlias12, Name fieldAlias13, Name fieldAlias14, Name fieldAlias15, Name fieldAlias16, Name fieldAlias17, Name fieldAlias18, Name fieldAlias19, Name fieldAlias20, Name fieldAlias21, Name fieldAlias22) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.DSL.xmlelement
(Name name, Collection<? extends Field<?>> content) The XML element constructor.DSL.xmlelement
(Name name, Field<?>... content) The XML element constructor.DSL.xmlelement
(Name name, XMLAttributes attributes, Collection<? extends Field<?>> content) The XML element constructor.DSL.xmlelement
(Name name, XMLAttributes attributes, Field<?>... content) The XML element constructor.TheXMLPI
function.TheXMLPI
function.Modifier and TypeMethodDescriptionDefaultDSLContext.createMaterializedView
(Name view, Collection<? extends Name> fields) static CreateViewAsStep<Record>
DSL.createMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW
statement.DefaultDSLContext.createMaterializedViewIfNotExists
(Name view, Collection<? extends Name> fields) static CreateViewAsStep<Record>
DSL.createMaterializedViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTS
statement.DefaultDSLContext.createOrReplaceMaterializedView
(Name view, Collection<? extends Name> fields) static CreateViewAsStep<Record>
DSL.createOrReplaceMaterializedView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE MATERIALIZED VIEW
statement.DefaultDSLContext.createOrReplaceView
(Name view, Collection<? extends Name> fields) DefaultDSLContext.createOrReplaceView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) DefaultDSLContext.createOrReplaceView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) static CreateViewAsStep<Record>
DSL.createOrReplaceView
(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE VIEW
statement.static @NotNull CreateViewAsStep<Record>
DSL.createOrReplaceView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.DefaultDSLContext.createView
(Name view, Collection<? extends Name> fields) DefaultDSLContext.createView
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) DefaultDSLContext.createView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) static CreateViewAsStep<Record>
DSL.createView
(Name view, Collection<? extends Name> fields) TheCREATE VIEW
statement.static @NotNull CreateViewAsStep<Record>
DSL.createView
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.DefaultDSLContext.createViewIfNotExists
(Name view, Collection<? extends Name> fields) DefaultDSLContext.createViewIfNotExists
(Name view, BiFunction<? super Field<?>, ? super Integer, ? extends Name> fieldNameFunction) DefaultDSLContext.createViewIfNotExists
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) static CreateViewAsStep<Record>
DSL.createViewIfNotExists
(Name view, Collection<? extends Name> fields) TheCREATE VIEW IF NOT EXISTS
statement.static @NotNull CreateViewAsStep<Record>
DSL.createViewIfNotExists
(Name view, Function<? super Field<?>, ? extends Name> fieldNameFunction) Deprecated, for removal: This API element is subject to removal in a future version.- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.DefaultDSLContext.with
(Name alias, Collection<? extends Name> fieldAliases) static @NotNull WithAsStep
DSL.with
(Name alias, Collection<? extends Name> fieldAliases) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.DefaultDSLContext.withRecursive
(Name alias, Collection<? extends Name> fieldAliases) static @NotNull WithAsStep
DSL.withRecursive
(Name alias, Collection<? extends Name> fieldAliases) Create aWITH
clause to supply subsequentSELECT
,UPDATE
,INSERT
,DELETE
, andMERGE
statements withCommonTableExpression
s.ModifierConstructorDescriptionCatalogImpl
(Name name) CatalogImpl
(Name name, Comment comment) protected
CustomField
(Name name, DataType<T> type) protected
CustomTable
(Name name) protected
CustomTable
(Name name, Schema schema) LazyCatalog
(Name name, LazySupplier<Catalog> supplier) LazySchema
(Name name, Comment comment, LazySupplier<Schema> supplier) SchemaImpl
(Name name) SchemaImpl
(Name name, Catalog catalog) SchemaImpl
(Name name, Catalog catalog, Comment comment) TableImpl
(Name name, Schema schema, Table<?> path, ForeignKey<?, R> childPath, InverseForeignKey<?, R> parentPath, Table<R> aliased, Field<?>[] parameters, Comment comment) TableImpl
(Name name, Schema schema, Table<?> path, ForeignKey<?, R> childPath, InverseForeignKey<?, R> parentPath, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options) Deprecated.- [#8012] - 3.19.0 - Please re-generate your code.TableImpl
(Name name, Schema schema, Table<?> path, ForeignKey<?, R> childPath, InverseForeignKey<?, R> parentPath, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options, Condition where) TableImpl
(Name name, Schema schema, Table<?> path, ForeignKey<?, R> childPath, Table<R> aliased, Field<?>[] parameters, Comment comment) Deprecated.- [#13639] [#14985] [#15005] - 3.19.0 - Please re-generate your code.TableImpl
(Name name, Schema schema, Table<?> path, ForeignKey<?, R> childPath, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options) Deprecated.- [#13639] [#14985] [#15005] - 3.19.0 - Please re-generate your code.Deprecated.- 3.11 - [#7027] - UseTableImpl(Name, Schema, Table, Field[], Comment)
instead.TableImpl
(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options) TableImpl
(Name name, Schema schema, Table<R> aliased, Field<?>[] parameters, Comment comment, TableOptions options, Condition where) UDTPathTableFieldImpl
(Name name, DataType<T> type, RecordQualifier<R> qualifier, UDT<U> udt, Comment comment, Binding<?, T> binding)