Uses of Interface
org.jooq.Name
Packages that use 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 NameLink.$name()Experimental query object model accessor method, see alsoQOM.@NotNull NameNamed.$name()Experimental query object model accessor method, see alsoQOM.@NotNull NameWindowDefinition.$name()Experimental query object model accessor method, see alsoQOM.@NotNull NameDerivedColumnList.$tableName()Experimental query object model accessor method, see alsoQOM.@NotNull NameAppendsnameto this name.@NotNull NameAppendsname(all of itsparts()) to this name.@NotNull NameNamed.getQualifiedName()The qualified name of this object.@NotNull NameNamed.getUnqualifiedName()The unqualified name of this object.@NotNull NameParseContext.parseIdentifier()Parse an (unqualified) identifier or fail if the current token is not an identifier.@Nullable NameParseContext.parseIdentifierIf()Try parsing an (unqualified) identifier.@NotNull NameParseContext.parseName()Parse a name (a qualified identifier) or fail if the current token is not a name.@NotNull NameParse a SQL string into a nameName.@NotNull NameParse a SQL string with bind variables into a nameName.@Nullable NameParseContext.parseNameIf()Try parsing a name (a qualified identifier).@NotNull Name @NotNull []Name.parts()Get the individual, unqualified name parts of this name.@Nullable NameName.qualifier()This name's qualifier (if it isqualified()), ornull.@NotNull NameName.quotedName()This name, quoted.final NameDatePart.toName()@NotNull NameName.unqualifiedName()This name, unqualified.@NotNull NameName.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 AlterTableAddStepAdd anADD COLUMNclause to theALTER TABLEstatement.@NotNull AlterTableAddStepAdd anADD COLUMNclause to theALTER TABLEstatement.@NotNull AlterTableAddStepAlterTableStep.addColumnIfNotExists(Name field, DataType<?> type) Add anADD COLUMN IF NOT EXISTSclause to theALTER TABLEstatement.@NotNull AlterTableAddStepAlterTableStep.addIfNotExists(Name field, DataType<?> type) Add anADD COLUMN IF NOT EXISTSclause to theALTER TABLEstatement.@NotNull AlterTableFinalStepAdd aAFTERclause toALTER TABLE … ADD ….@NotNull AlterTableAlterStep<Object> Add anALTER COLUMNclause to theALTER TABLEstatement.@NotNull AlterTableAlterStep<Object> AlterTableStep.alterColumn(Name field) Add anALTER COLUMNclause to theALTER TABLEstatement.@NotNull AlterTableAlterConstraintStepAlterTableStep.alterConstraint(Name constraint) Add anALTER CONSTRAINTclause to theALTER TABLEstatement.@NotNull AlterDatabaseStepDSLContext.alterDatabase(Name database) TheALTER DATABASEstatement.@NotNull AlterDatabaseStepDSLContext.alterDatabaseIfExists(Name database) TheALTER DATABASE IF EXISTSstatement.<T> @NotNull AlterDomainStep<T> DSLContext.alterDomain(Name domain) TheALTER DOMAINstatement.<T> @NotNull AlterDomainStep<T> DSLContext.alterDomainIfExists(Name domain) TheALTER DOMAIN IF EXISTSstatement.@NotNull AlterIndexOnStepDSLContext.alterIndex(Name index) TheALTER INDEXstatement.@NotNull AlterIndexOnStepDSLContext.alterIndexIfExists(Name index) TheALTER INDEX IF EXISTSstatement.@NotNull AlterViewStepDSLContext.alterMaterializedView(Name view) TheALTER MATERIALIZED VIEWstatement.@NotNull AlterViewStepDSLContext.alterMaterializedViewIfExists(Name view) TheALTER MATERIALIZED VIEW IF EXISTSstatement.@NotNull AlterSchemaStepDSLContext.alterSchema(Name schema) TheALTER SCHEMAstatement.@NotNull AlterSchemaStepDSLContext.alterSchemaIfExists(Name schema) TheALTER SCHEMA IF EXISTSstatement.@NotNull AlterSequenceStep<Number> DSLContext.alterSequence(Name sequence) TheALTER SEQUENCEstatement.@NotNull AlterSequenceStep<Number> DSLContext.alterSequenceIfExists(Name sequence) TheALTER SEQUENCE IF EXISTSstatement.@NotNull AlterTableStepDSLContext.alterTable(Name table) Create a new DSLALTER TABLEstatement.@NotNull AlterTableStepDSLContext.alterTableIfExists(Name table) Create a new DSLALTER TABLEstatement.@NotNull AlterTypeStepTheALTER TYPEstatement.@NotNull AlterTypeStepDSLContext.alterTypeIfExists(Name type) TheALTER TYPE IF EXISTSstatement.@NotNull AlterViewStepTheALTER VIEWstatement.@NotNull AlterViewStepDSLContext.alterViewIfExists(Name view) TheALTER VIEW IF EXISTSstatement.@NotNull NameAppendsname(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 thisTableLikeexpression 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 AlterTableFinalStepAdd aBEFOREclause toALTER TABLE … ADD ….@NotNull CallArgsStepTheCALLstatement.booleanDeprecated, for removal: This API element is subject to removal in a future version.- [#12494] - 3.20.0 - UseRecord.touched(Name)instead.voidDeprecated, for removal: This API element is subject to removal in a future version.- [#12494] - 3.20.0 - UseRecord.touched(Name, boolean)instead.Apply a collation operator to this column expression.@NotNull CreateTableElementListStepAdd theCOLUMNclause to theCREATE TABLEstatement.@NotNull JSONTableColumnForOrdinalityStepAdd a column to theCOLUMNSclause of theJSON_TABLEexpression.@NotNull JSONTableColumnPathStepAdd a column to theCOLUMNSclause of theJSON_TABLEexpression.@NotNull XMLTableColumnForOrdinalityStepAdd a column to theCOLUMNSclause of theXMLTABLEexpression.@NotNull XMLTableColumnPathStepAdd a column to theCOLUMNSclause of theXMLTABLEexpression.@NotNull CreateTableElementListStepAdd theCOLUMNSclause to theCREATE TABLEstatement.@NotNull CommentOnIsStepDSLContext.commentOnColumn(Name field) TheCOMMENT ON COLUMNstatement.@NotNull CommentOnIsStepDSLContext.commentOnMaterializedView(Name view) TheCOMMENT ON MATERIALIZED VIEWstatement.@NotNull CommentOnIsStepDSLContext.commentOnTable(Name table) TheCOMMENT ON TABLEstatement.@NotNull CommentOnIsStepDSLContext.commentOnView(Name view) TheCOMMENT ON VIEWstatement.intCompare twounquotedName()by their qualified string versions.@NotNull CreateDatabaseFinalStepDSLContext.createDatabase(Name database) TheCREATE DATABASEstatement.@NotNull CreateDatabaseFinalStepDSLContext.createDatabaseIfNotExists(Name database) TheCREATE DATABASE IF NOT EXISTSstatement.@NotNull CreateDomainAsStepDSLContext.createDomain(Name domain) TheCREATE DOMAINstatement.@NotNull CreateDomainAsStepDSLContext.createDomainIfNotExists(Name domain) TheCREATE DOMAIN IF NOT EXISTSstatement.@NotNull CreateFunctionParametersStepDSLContext.createFunction(Name function) TheCREATE FUNCTIONstatement.@NotNull CreateTableElementListStepDSLContext.createGlobalTemporaryTable(Name table) TheCREATE GLOBAL TEMPORARY TABLEstatement.@NotNull CreateTableElementListStepDSLContext.createGlobalTemporaryTableIfNotExists(Name table) TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTSstatement.@NotNull CreateIndexStepDSLContext.createIndex(Name index) TheCREATE INDEXstatement.@NotNull CreateIndexStepDSLContext.createIndexIfNotExists(Name index) TheCREATE INDEX IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedView(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedView(Name view, Name... fields) TheCREATE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedViewIfNotExists(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedViewIfNotExists(Name view, Name... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.@NotNull CreateFunctionParametersStepDSLContext.createOrReplaceFunction(Name function) TheCREATE OR REPLACE FUNCTIONstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceMaterializedView(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceMaterializedView(Name view, Name... fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.@NotNull CreateProcedureParametersStepDSLContext.createOrReplaceProcedure(Name procedure) TheCREATE OR REPLACE PROCEDUREstatement.@NotNull CreateSynonymForStepDSLContext.createOrReplacePublicSynonym(Name synonym) TheCREATE OR REPLACE PUBLIC SYNONYMstatement.@NotNull CreateSynonymForStepDSLContext.createOrReplaceSynonym(Name synonym) TheCREATE OR REPLACE SYNONYMstatement.@NotNull CreateTriggerEventStepDSLContext.createOrReplaceTrigger(Name trigger) TheCREATE OR REPLACE TRIGGERstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceView(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE VIEWstatement.@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 VIEWstatement.@NotNull CreateProcedureParametersStepDSLContext.createProcedure(Name procedure) TheCREATE PROCEDUREstatement.@NotNull CreateSynonymForStepDSLContext.createPublicSynonym(Name synonym) TheCREATE PUBLIC SYNONYMstatement.@NotNull CreateSchemaFinalStepDSLContext.createSchema(Name schema) TheCREATE SCHEMAstatement.@NotNull CreateSchemaFinalStepDSLContext.createSchemaIfNotExists(Name schema) TheCREATE SCHEMA IF NOT EXISTSstatement.@NotNull CreateSequenceAsStep<Number> DSLContext.createSequence(Name sequence) TheCREATE SEQUENCEstatement.@NotNull CreateSequenceAsStep<Number> DSLContext.createSequenceIfNotExists(Name sequence) TheCREATE SEQUENCE IF NOT EXISTSstatement.@NotNull CreateSynonymForStepDSLContext.createSynonym(Name synonym) TheCREATE SYNONYMstatement.@NotNull CreateTableElementListStepDSLContext.createTable(Name table) TheCREATE TABLEstatement.@NotNull CreateTableElementListStepDSLContext.createTableIfNotExists(Name table) TheCREATE TABLE IF NOT EXISTSstatement.@NotNull CreateTableElementListStepDSLContext.createTemporaryTable(Name table) TheCREATE TEMPORARY TABLEstatement.@NotNull CreateTableElementListStepDSLContext.createTemporaryTableIfNotExists(Name table) TheCREATE TEMPORARY TABLE IF NOT EXISTSstatement.@NotNull CreateTriggerEventStepDSLContext.createTrigger(Name trigger) TheCREATE TRIGGERstatement.@NotNull CreateTypeStepDSLContext.createType(Name type) TheCREATE TYPEstatement.@NotNull CreateTypeStepDSLContext.createTypeIfNotExists(Name type) TheCREATE TYPE IF NOT EXISTSstatement.@NotNull CreateIndexStepDSLContext.createUniqueIndex(Name index) TheCREATE UNIQUE INDEXstatement.@NotNull CreateIndexStepDSLContext.createUniqueIndexIfNotExists(Name index) TheCREATE UNIQUE INDEX IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createView(Name view, Collection<? extends Name> fields) TheCREATE VIEWstatement.@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 VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createViewIfNotExists(Name view, Collection<? extends Name> fields) TheCREATE VIEW IF NOT EXISTSstatement.@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 EXISTSstatement.@NotNull SelectJoinStep<R> SelectJoinStep.crossApply(Name name) CROSS APPLYa table to this table.Table.crossApply(Name name) CROSS APPLYa table to this table.@NotNull SelectJoinStep<R> Convenience method toCROSS JOINa table to the last table added to theFROMclause usingTable.crossJoin(Name)CROSS JOINa table to this table.@NotNull BigIntegerConvenience 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, ornullif no field is known to this type by this name.@NotNull AlterTableDropStepAdd anDROP COLUMNclause to theALTER TABLEstatement.@NotNull AlterTableDropStepAdd anDROP COLUMNclause to theALTER TABLEstatement.@NotNull AlterTableDropStepAlterTableStep.dropColumn(Name field) Add anDROP COLUMNclause to theALTER TABLEstatement.@NotNull AlterTableDropStepAlterTableStep.dropColumnIfExists(Name field) Add anDROP COLUMN IF EXISTSclause to theALTER TABLEstatement.@NotNull AlterTableDropStepAlterTableStep.dropColumns(Name... fields) Add anDROP COLUMNclause to theALTER TABLEstatement.@NotNull AlterDomainDropConstraintCascadeStepAlterDomainStep.dropConstraint(Name dropConstraint) Add theDROP CONSTRAINTclause to theALTER DOMAINstatement.@NotNull AlterTableDropStepAlterTableStep.dropConstraint(Name constraint) Add aDROP CONSTRAINTclause to theALTER TABLEstatement.@NotNull AlterDomainDropConstraintCascadeStepAlterDomainStep.dropConstraintIfExists(Name dropConstraint) Add theDROP CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement.@NotNull AlterTableDropStepAlterTableStep.dropConstraintIfExists(Name constraint) Add aDROP CONSTRAINT IF EXISTSclause to theALTER TABLEstatement.@NotNull DropDatabaseFinalStepDSLContext.dropDatabase(Name database) TheDROP DATABASEstatement.@NotNull DropDatabaseFinalStepDSLContext.dropDatabaseIfExists(Name database) TheDROP DATABASE IF EXISTSstatement.@NotNull DropDomainCascadeStepDSLContext.dropDomain(Name domain) TheDROP DOMAINstatement.@NotNull DropDomainCascadeStepDSLContext.dropDomainIfExists(Name domain) TheDROP DOMAIN IF EXISTSstatement.@NotNull AlterTableDropStepAlterTableStep.dropForeignKey(Name constraint) Add aDROP FOREIGN KEYclause to theALTER TABLEstatement.@NotNull DDLQueryDSLContext.dropFunction(Name function) TheDROP FUNCTIONstatement.@NotNull DDLQueryDSLContext.dropFunctionIfExists(Name function) TheDROP FUNCTION IF EXISTSstatement.@NotNull AlterTableDropStepAlterTableStep.dropIfExists(Name field) Add anDROP COLUMN IF EXISTSclause to theALTER TABLEstatement.@NotNull DropIndexOnStepTheDROP INDEXstatement.@NotNull DropIndexOnStepDSLContext.dropIndexIfExists(Name index) TheDROP INDEX IF EXISTSstatement.@NotNull DropViewFinalStepDSLContext.dropMaterializedView(Name view) TheDROP MATERIALIZED VIEWstatement.@NotNull DropViewFinalStepDSLContext.dropMaterializedViewIfExists(Name view) TheDROP MATERIALIZED VIEW IF EXISTSstatement.@NotNull AlterTableDropStepAlterTableStep.dropPrimaryKey(Name constraint) Add aDROP PRIMARY KEYclause to theALTER TABLEstatement.@NotNull DDLQueryDSLContext.dropProcedure(Name procedure) TheDROP PROCEDUREstatement.@NotNull DDLQueryDSLContext.dropProcedureIfExists(Name procedure) TheDROP PROCEDURE IF EXISTSstatement.@NotNull DDLQueryDSLContext.dropPublicSynonym(Name synonym) TheDROP PUBLIC SYNONYMstatement.@NotNull DDLQueryDSLContext.dropPublicSynonymIfExists(Name synonym) TheDROP PUBLIC SYNONYM IF EXISTSstatement.@NotNull DropSchemaStepDSLContext.dropSchema(Name schema) TheDROP SCHEMAstatement.@NotNull DropSchemaStepDSLContext.dropSchemaIfExists(Name schema) TheDROP SCHEMA IF EXISTSstatement.@NotNull DropSequenceFinalStepDSLContext.dropSequence(Name sequence) TheDROP SEQUENCEstatement.@NotNull DropSequenceFinalStepDSLContext.dropSequenceIfExists(Name sequence) TheDROP SEQUENCE IF EXISTSstatement.@NotNull DDLQueryDSLContext.dropSynonym(Name synonym) TheDROP SYNONYMstatement.@NotNull DDLQueryDSLContext.dropSynonymIfExists(Name synonym) TheDROP SYNONYM IF EXISTSstatement.@NotNull DropTableStepTheDROP TABLEstatement.@NotNull DropTableStepDSLContext.dropTableIfExists(Name table) TheDROP TABLE IF EXISTSstatement.@NotNull DropTableStepDSLContext.dropTemporaryTable(Name table) TheDROP TEMPORARY TABLEstatement.@NotNull DropTableStepDSLContext.dropTemporaryTableIfExists(Name table) TheDROP TEMPORARY TABLE IF EXISTSstatement.@NotNull DropTriggerOnStepDSLContext.dropTrigger(Name trigger) TheDROP TRIGGERstatement.@NotNull DropTriggerOnStepDSLContext.dropTriggerIfExists(Name trigger) TheDROP TRIGGER IF EXISTSstatement.@NotNull DropTypeStepTheDROP TYPEstatement.@NotNull DropTypeStepTheDROP TYPEstatement.@NotNull DropTypeStepDSLContext.dropTypeIfExists(Name types) TheDROP TYPE IF EXISTSstatement.@NotNull DropTypeStepDSLContext.dropTypeIfExists(Name... types) TheDROP TYPE IF EXISTSstatement.@NotNull AlterTableDropStepAlterTableStep.dropUnique(Name constraint) Add aDROP UNIQUEclause to theALTER TABLEstatement.@NotNull DropViewFinalStepTheDROP VIEWstatement.@NotNull DropViewFinalStepDSLContext.dropViewIfExists(Name view) TheDROP VIEW IF EXISTSstatement.booleanName.equalsIgnoreCase(Name other) Compare this name with another one ignoring case.@NotNull AsteriskThe asterisk (*) to be used inSELECTclauses.@NotNull QualifiedAsteriskThe qualified asterisk (t.* EXCEPT (fields)) expression to be used inSELECTclauses.@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 ObjectExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<U> UExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<U> UExecute 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 aMapwith 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 aMapwith 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 aMapwith 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 aMapwith 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 aMapwith 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 aMapwith 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 aMapwith 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 aMapwith results grouped by the given key and mapped by the given mapper, usingFields.field(Name)for lookup.Execute the query and return aMapwith one of the result's columns as key and the corresponding records as value, usingFields.field(Name)for lookup.Execute the query and return aMapwith keys as a map key and the corresponding record as value, usingFields.field(Name)for lookup.Execute the query and return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)for lookup.Execute the query and return aMapwith 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 aMapwith 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 aMapwith 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 aMapwith 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 aMapwith results grouped by the given key and mapped by the given mapper, usingFields.field(Name)for lookup.@Nullable ObjectExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<U> UExecute the query and return at most one resulting value for a field name from the generated result, usingFields.field(Name)for lookup.<U> UExecute 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 ObjectResultQuery.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> UResultQuery.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> UResultQuery.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, ornullif 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 totypeusingField.coerce(Class), ornullif 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 todataTypeusingField.coerce(DataType), ornullif 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 DerivedColumnList1Add a list of fields to this name to make this name aDerivedColumnList.@NotNull DerivedColumnListAdd a list of fields to this name to make this name aDerivedColumnList.@NotNull DerivedColumnList2Add a list of fields to this name to make this name aDerivedColumnList.@NotNull DerivedColumnList3Add a list of fields to this name to make this name aDerivedColumnList.@NotNull DerivedColumnList4Add a list of fields to this name to make this name aDerivedColumnList.@NotNull DerivedColumnList5Add a list of fields to this name to make this name aDerivedColumnList.@NotNull DerivedColumnList6Name.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 DerivedColumnList7Name.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 DerivedColumnList8Name.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 DerivedColumnList9Name.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 DerivedColumnList10Name.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 DerivedColumnList11Name.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 DerivedColumnList12Name.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 DerivedColumnList13Name.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 DerivedColumnList14Name.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 DerivedColumnList15Name.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 DerivedColumnList16Name.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 DerivedColumnList17Name.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 DerivedColumnList18Name.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 DerivedColumnList19Name.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 DerivedColumnList20Name.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 DerivedColumnList21Name.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 DerivedColumnList22Name.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 DDLQueryAdd theFORclause to theCREATE SYNONYMstatement.@NotNull ConstraintForeignKeyReferencesStep1<?> ConstraintTypeStep.foreignKey(Name field1) Add aFOREIGN KEYclause to theCONSTRAINT.@NotNull ConstraintForeignKeyReferencesStepNConstraintTypeStep.foreignKey(Name... fields) Add aFOREIGN KEYclause to theCONSTRAINT.@NotNull ConstraintForeignKeyReferencesStep2<?, ?> ConstraintTypeStep.foreignKey(Name field1, Name field2) Add aFOREIGN KEYclause to theCONSTRAINT.@NotNull ConstraintForeignKeyReferencesStep3<?, ?, ?> ConstraintTypeStep.foreignKey(Name field1, Name field2, Name field3) Add aFOREIGN KEYclause to theCONSTRAINT.@NotNull ConstraintForeignKeyReferencesStep4<?, ?, ?, ?> ConstraintTypeStep.foreignKey(Name field1, Name field2, Name field3, Name field4) Add aFOREIGN KEYclause to theCONSTRAINT.@NotNull ConstraintForeignKeyReferencesStep5<?, ?, ?, ?, ?> Add aFOREIGN KEYclause to theCONSTRAINT.@NotNull ConstraintForeignKeyReferencesStep6<?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6) Add aFOREIGN KEYclause to theCONSTRAINT.@NotNull ConstraintForeignKeyReferencesStep7<?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7) Add aFOREIGN KEYclause to theCONSTRAINT.@NotNull ConstraintForeignKeyReferencesStep8<?, ?, ?, ?, ?, ?, ?, ?> ConstraintTypeStep.foreignKey(Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8) Add aFOREIGN KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause to theCONSTRAINT.voidLoad data into this record from a source, providing some field names, usingFields.field(Name)for lookup.@NotNull SelectJoinStep<R> Add aFROMclause to the query.@NotNull UpdateWhereStep<R> Add aFROMclause to the query.voidLoad data from an array into this record, providing some fields names, usingFields.field(Name)for lookup.voidLoad data from a map into this record, providing some field names, usingFields.field(Name)for lookup.@NotNull SelectOnStep<R> Convenience method toFULL OUTER JOINa tableto the last table added to theFROMclause usingTable.fullOuterJoin(Name).@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> FULL OUTER JOINa table to this table.@NotNull SelectOnStep<R> SelectJoinStep.fullOuterJoin(Name name) Convenience method toFULL OUTER JOINa tableto the last table added to theFROMclause usingTable.fullOuterJoin(Name)@NotNull TablePartitionByStep<Record> Table.fullOuterJoin(Name name) FULL OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.fullOuterJoin(Name name) FULL OUTER JOINa table to this table.@Nullable ObjectGet a value from this Record, providing a field name, usingFields.field(Name)for lookup.<U> UGet a converted value from this Record, providing a field name, usingFields.field(Name)for lookup.<U> UGet a converted value from this Record, providing a field name, usingFields.field(Name)for lookup.@NotNull CatalogMeta.getCatalog(Name name) Get a catalog object by name from the underlying meta data source, ornullif no such object exists.@Nullable Domain<?> Get a domain by its qualified or unqualified name in this schema, ornullif 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.Meta.getPublicSynonyms(Name name) Get all public synonym objects by name from the underlying meta data source.@Nullable SchemaGet a schema by its qualified or unqualified name in this catalog, ornullif 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, ornullif no such sequence exists.Meta.getSequences(Name name) Get all sequence objects by name from the underlying meta data source.@Nullable SynonymSchema.getSynonym(Name name) Get a synonym by its qualified or unqualified name in this schema, ornullif no such synonym exists.Meta.getSynonyms(Name name) Get all synonym objects by name from the underlying meta data source.@Nullable Table<?> Get a table by its qualified or unqualified name in this schema, ornullif no such table exists.Get all table objects by name from the underlying meta data source.@Nullable TriggerSchema.getTrigger(Name name) Get a trigger by its qualified or unqualified name in this schema, ornullif 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, ornullif 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> TGet a converted value from this Record, providing a field name, usingFields.field(Name)for lookup.<U> UGet 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 CreateIndexWhereStepAdd theINCLUDEclause to theCREATE INDEXstatement.intGet a field's index from this type.@NotNull SelectOnStep<R> Convenience method toINNER JOINa table to the last table added to theFROMclause usingTable.join(Name).@NotNull TableOnStep<Record> INNER JOINa table to this table.@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 aMapwith 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 aMapwith the result grouped by the given keys, usingFields.field(Name)for lookup.Result.intoGroups(Name[] keyFieldNames, Class<? extends E> type) Return aMapwith 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 aMapwith the result grouped by the given keys, usingFields.field(Name)for lookup.Result.intoGroups(Name[] keyFieldNames, RecordMapper<? super R, E> mapper) Return aMapwith 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 aMapwith 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 aMapwith 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 aMapwith results grouped by the given key and mapped by the given mapper, usingFields.field(Name)for lookup.Return aMapwith one of the result's columns as key and the corresponding records as value, usingFields.field(Name)for lookup.Return aMapwith the given keys as a map key and the corresponding record as value, usingFields.field(Name)for lookup.Return aMapwith results grouped by the given keys and mapped into the given entity type, usingFields.field(Name)for lookup.Return aMapwith 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 aMapwith results grouped by the given keys and mapped by the given mapper, usingFields.field(Name)for lookup.<E> @NotNull Map<?, E> Return aMapwith results grouped by the given key and mapped into the given entity type, usingFields.field(Name)for lookup.@NotNull Map<?, ?> Return aMapwith 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 aMapwith 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 JOINa table to the last table added to theFROMclause usingTable.join(Name).@NotNull TableOnStep<Record> INNER JOINa table to this table.@NotNull SelectJoinPartitionByStep<R> Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterJoin(Name).@NotNull TablePartitionByStep<Record> LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> LEFT OUTER JOINa table to this table.@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.leftOuterJoin(Name name) Convenience method toLEFT OUTER JOINa table to the last table added to theFROMclause usingTable.leftOuterJoin(Name)@NotNull TablePartitionByStep<Record> Table.leftOuterJoin(Name name) LEFT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.leftOuterJoin(Name name) LEFT OUTER JOINa table to this table.booleanCheck if a field's value has been modified since the record was created or fetched from the database, usingFields.field(Name)for lookup.@NotNull SelectJoinStep<R> SelectJoinStep.naturalFullOuterJoin(Name name) Convenience method toNATURAL FULL OUTER JOINa table to the last table added to theFROMclause usingTable.naturalFullOuterJoin(Name)Table.naturalFullOuterJoin(Name name) NATURAL FULL OUTER JOINa table to this table.@NotNull SelectJoinStep<R> SelectJoinStep.naturalJoin(Name name) Convenience method toNATURAL JOINa table to the last table added to theFROMclause usingTable.naturalJoin(Name)Table.naturalJoin(Name name) NATURAL JOINa table to this table.@NotNull SelectJoinStep<R> SelectJoinStep.naturalLeftOuterJoin(Name name) Convenience method toNATURAL LEFT OUTER JOINa table to the last table added to theFROMclause usingTable.naturalLeftOuterJoin(Name)Table.naturalLeftOuterJoin(Name name) NATURAL LEFT OUTER JOINa table to this table.@NotNull SelectJoinStep<R> SelectJoinStep.naturalRightOuterJoin(Name name) Convenience method toNATURAL RIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.naturalRightOuterJoin(Name)Table.naturalRightOuterJoin(Name name) NATURAL RIGHT OUTER JOINa table to this table.@NotNull BigIntegerConvenience method to fetch the NEXTVAL for a sequence directly from thisDSLContext's underlying JDBCConnection.@NotNull CreateTriggerEventOrStepAdd theOFclause to theCREATE TRIGGERstatement.@NotNull AlterIndexStepAdd theONclause to theALTER INDEXstatement.@NotNull CreateIndexIncludeStepCreateIndexStep.on(Name table, Collection<? extends Name> on) Add theONclause to theCREATE INDEXstatement.@NotNull CreateIndexIncludeStepAdd theONclause to theCREATE INDEXstatement.@NotNull CreateTriggerReferencingStepAdd theONclause to theCREATE TRIGGERstatement.@NotNull DropIndexCascadeStepAdd theONclause to theDROP INDEXstatement.@NotNull DDLQueryAdd theONclause to theDROP TRIGGERstatement.@NotNull GrantToStepAdd theONclause to theGRANTstatement.@NotNull RevokeFromStepAdd theONclause to theREVOKEstatement.@NotNull InsertOnConflictDoUpdateStep<R> InsertOnDuplicateStep.onConflictOnConstraint(Name constraint) Add aON CONFLICT ON CONSTRAINTclause to this INSERT statement.voidInsertQuery.onConflictOnConstraint(Name constraint) Whether use aON CONFLICTorON CONFLICT ON CONSTRAINTclause in thisINSERTstatement.@Nullable ObjectGet an original value from this record as fetched from the database, usingFields.field(Name)for lookup.@NotNull SelectJoinStep<R> SelectJoinStep.outerApply(Name name) OUTER APPLYa table to this table.Table.outerApply(Name name) OUTER APPLYa table to this table.@NotNull WindowFinalStep<T> Turn this aggregate function into a window function referencing a window name.@NotNull ConstraintEnforcementStepConstraintTypeStep.primaryKey(Name... fields) Create aPRIMARY KEYconstraint.@NotNull CreateTableElementListStepCreateTableElementListStep.primaryKey(Name... fields) Add thePRIMARY KEYclause to theCREATE TABLEstatement.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep1.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep1.references(Name table, Name field1) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep10.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep10.references(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9, Name field10) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep11.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep11.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 aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep12.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep12.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 aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep13.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep13.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 aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep14.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep14.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 aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep15.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep15.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 aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep16.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep16.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 aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep17.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep17.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 aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep18.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep18.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 aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep19.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep19.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 aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep2.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep2.references(Name table, Name field1, Name field2) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep20.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep20.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 aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep21.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep21.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 aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep22.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep22.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 aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep3.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep3.references(Name table, Name field1, Name field2, Name field3) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep4.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep4.references(Name table, Name field1, Name field2, Name field3, Name field4) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep5.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep5.references(Name table, Name field1, Name field2, Name field3, Name field4, Name field5) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep6.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep6.references(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep7.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep7.references(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep8.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep8.references(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep9.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStep9.references(Name table, Name field1, Name field2, Name field3, Name field4, Name field5, Name field6, Name field7, Name field8, Name field9) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStepN.references(Name table) Add aREFERENCESclause to theCONSTRAINT, implicitly referencing the primary key.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStepN.references(Name table, Collection<? extends Name> fields) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStepN.references(Name table, Name... fields) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull CreateTriggerReferencingStepCreateTriggerReferencingStep.referencingNewAs(Name referencingNewAs) Add theREFERENCING NEW ASclause to theCREATE TRIGGERstatement.@NotNull CreateTriggerReferencingStepCreateTriggerReferencingStep.referencingOldAs(Name referencingOldAs) Add theREFERENCING OLD ASclause to theCREATE TRIGGERstatement.@NotNull RowCountQueryDSLContext.releaseSavepoint(Name name) TheRELEASE SAVEPOINTstatement.@NotNull AlterTableRenameColumnToStepAlterTableStep.renameColumn(Name oldName) Add aRENAME COLUMNclause to theALTER TABLEstatement.@NotNull AlterDomainRenameConstraintStepAlterDomainStep.renameConstraint(Name renameConstraint) Add theRENAME CONSTRAINTclause to theALTER DOMAINstatement.@NotNull AlterTableRenameConstraintToStepAlterTableStep.renameConstraint(Name oldName) Add aRENAME CONSTRAINTclause to theALTER TABLEstatement.@NotNull AlterDomainRenameConstraintStepAlterDomainStep.renameConstraintIfExists(Name renameConstraint) Add theRENAME CONSTRAINT IF EXISTSclause to theALTER DOMAINstatement.@NotNull AlterTableRenameIndexToStepAlterTableStep.renameIndex(Name oldName) Add aRENAME INDEXclause to theALTER TABLEstatement.@NotNull AlterDatabaseFinalStepAdd theRENAME TOclause to theALTER DATABASEstatement.@NotNull AlterDomainFinalStepAdd theRENAME TOclause to theALTER DOMAINstatement.@NotNull AlterIndexFinalStepAdd theRENAME TOclause to theALTER INDEXstatement.@NotNull AlterSchemaFinalStepAdd theRENAME TOclause to theALTER SCHEMAstatement.@NotNull AlterSequenceFinalStepAdd theRENAME TOclause to theALTER SEQUENCEstatement.@NotNull AlterTableFinalStepAdd aRENAME TOclause to theALTER TABLEstatement.@NotNull AlterTypeFinalStepAdd theRENAME TOclause to theALTER TYPEstatement.@NotNull AlterViewFinalStepAdd theRENAME TOclause to theALTER VIEWstatement.voidReset a given value to itsRecord.original(Name)value and itsRecord.touched(Name)flag tofalse, usingFields.field(Name)for lookup.@NotNull SelectJoinPartitionByStep<R> Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterJoin(Name).@NotNull TablePartitionByStep<Record> RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> RIGHT OUTER JOINa table to this table.@NotNull SelectJoinPartitionByStep<R> SelectJoinStep.rightOuterJoin(Name name) Convenience method toRIGHT OUTER JOINa table to the last table added to theFROMclause usingTable.rightOuterJoin(Name)@NotNull TablePartitionByStep<Record> Table.rightOuterJoin(Name name) RIGHT OUTER JOINa table to this table.@NotNull TablePartitionByStep<Record> TableOuterJoinStep.rightOuterJoin(Name name) RIGHT OUTER JOINa table to this table.@NotNull RowCountQueryTheSAVEPOINTstatement.@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 RowCountQueryTheSETstatement.@NotNull RowCountQueryDSLContext.setCatalog(Name catalog) TheSET CATALOGstatement.@NotNull RowCountQueryTheSET LOCALstatement.@NotNull AlterTypeFinalStepAdd theSET SCHEMAclause to theALTER TYPEstatement.@NotNull RowCountQueryTheSET SCHEMAstatement.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_JOINa table to this table.@NotNull TableOnStep<Record> Table.straightJoin(Name name) STRAIGHT_JOINa table to this table.@NotNull AlterDomainFinalStepAdd theTOclause to theALTER DOMAINstatement.@NotNull AlterTableFinalStepSpecify a new column name.@NotNull AlterTableFinalStepSpecify a new constraint name.@NotNull AlterTableFinalStepSpecify a new index name.@NotNull RowCountQueryRollbackToSavepointStep.toSavepoint(Name toSavepoint) Add theTO SAVEPOINTclause to theROLLBACKstatement.booleanCheck if a field's value has been touched since the record was created or fetched from the database, usingFields.field(Name)for lookup.voidSet this record's internal touched flag to the supplied value for a given field, usingFields.field(Name)for lookup.@NotNull TruncateIdentityStep<Record> TheTRUNCATEstatement.@NotNull TruncateIdentityStep<Record> TheTRUNCATEstatement.@NotNull TruncateIdentityStep<Record> DSLContext.truncateTable(Name table) TheTRUNCATE TABLEstatement.@NotNull TruncateIdentityStep<Record> DSLContext.truncateTable(Name... table) TheTRUNCATE TABLEstatement.@Nullable Class<?> Get the field type for a given qualified field name, ornullif no field is known to this type by this name.@NotNull ConstraintEnforcementStepCreate aUNIQUEconstraint.@NotNull CreateTableElementListStepAdd theUNIQUEclause to theCREATE TABLEstatement.@NotNull DeleteWhereStep<R> Add aUSINGclause to the query.@NotNull AlterTableFinalStepAlterTableUsingIndexStep.usingIndex(Name index) Add theUSING INDEXclause to the statement.@NotNull WithAsStepCreate aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStepDSLContext.with(Name alias, Collection<? extends Name> fieldAliases) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep1Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStepCreate aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep2Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep3Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep4Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep5DSLContext.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep6DSLContext.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep7DSLContext.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep8DSLContext.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep9DSLContext.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep10DSLContext.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep11DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep12DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep13DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep14DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep15DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep16DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep17DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep18DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep19DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep20DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep21DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep22DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStepAdd another common table expression to theWITHclause.@NotNull WithAsStepWithStep.with(Name alias, Collection<? extends Name> fieldAliases) Add another common table expression to theWITHclause.@NotNull WithAsStep1Add another common table expression to theWITHclause.@NotNull WithAsStepAdd another common table expression to theWITHclause.@NotNull WithAsStep2Add another common table expression to theWITHclause.@NotNull WithAsStep3Add another common table expression to theWITHclause.@NotNull WithAsStep4Add another common table expression to theWITHclause.@NotNull WithAsStep5WithStep.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) Add another common table expression to theWITHclause.@NotNull WithAsStep6WithStep.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) Add another common table expression to theWITHclause.@NotNull WithAsStep7WithStep.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) Add another common table expression to theWITHclause.@NotNull WithAsStep8WithStep.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 theWITHclause.@NotNull WithAsStep9WithStep.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 theWITHclause.@NotNull WithAsStep10WithStep.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 theWITHclause.@NotNull WithAsStep11WithStep.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 theWITHclause.@NotNull WithAsStep12WithStep.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 theWITHclause.@NotNull WithAsStep13WithStep.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 theWITHclause.@NotNull WithAsStep14WithStep.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 theWITHclause.@NotNull WithAsStep15WithStep.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 theWITHclause.@NotNull WithAsStep16WithStep.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 theWITHclause.@NotNull WithAsStep17WithStep.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 theWITHclause.@NotNull WithAsStep18WithStep.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 theWITHclause.@NotNull WithAsStep19WithStep.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 theWITHclause.@NotNull WithAsStep20WithStep.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 theWITHclause.@NotNull WithAsStep21WithStep.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 theWITHclause.@NotNull WithAsStep22WithStep.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 theWITHclause.@NotNull WithAsStepDSLContext.withRecursive(Name alias) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStepDSLContext.withRecursive(Name alias, Collection<? extends Name> fieldAliases) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep1DSLContext.withRecursive(Name alias, Name fieldAlias1) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStepDSLContext.withRecursive(Name alias, Name... fieldAliases) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep2DSLContext.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep3DSLContext.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep4DSLContext.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep5DSLContext.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep6DSLContext.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep7DSLContext.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep8DSLContext.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep9DSLContext.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep10DSLContext.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep11DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep12DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep13DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep14DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep15DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep16DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep17DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep18DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep19DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep20DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep21DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStep22DSLContext.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.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 VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createMaterializedViewIfNotExists(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceMaterializedView(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.@NotNull CreateViewAsStep<Record> DSLContext.createOrReplaceView(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE VIEWstatement.@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 VIEWstatement.@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 EXISTSstatement.@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 CreateIndexIncludeStepCreateIndexStep.on(Name table, Collection<? extends Name> on) Add theONclause to theCREATE INDEXstatement.@NotNull ConstraintForeignKeyOnStepConstraintForeignKeyReferencesStepN.references(Name table, Collection<? extends Name> fields) Add aREFERENCESclause to theCONSTRAINT, referencing a key by column names.@NotNull WithAsStepDSLContext.with(Name alias, Collection<? extends Name> fieldAliases) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.@NotNull WithAsStepWithStep.with(Name alias, Collection<? extends Name> fieldAliases) Add another common table expression to theWITHclause.@NotNull WithAsStepDSLContext.withRecursive(Name alias, Collection<? extends Name> fieldAliases) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions. -
Uses of Name in org.jooq.impl
Methods in org.jooq.impl that return NameModifier and TypeMethodDescription@Nullable NameQOM.Aliasable.$alias()The alias if any.@NotNull NameQOM.FieldAlias.$alias()@NotNull NameQOM.TableAlias.$alias()final NameTableImpl.$alias()@NotNull NameQOM.XMLElement.$elementName()@NotNull NameQOM.CreateFunction.$function()@NotNull NameQOM.DropFunction.$function()@NotNull NameQOM.Check.$name()@NotNull NameQOM.ForeignKey.$name()@NotNull NameQOM.Label.$name()@NotNull NameQOM.PrimaryKey.$name()@NotNull NameQOM.ReleaseSavepoint.$name()@NotNull NameQOM.Savepoint.$name()@NotNull NameQOM.SetCommand.$name()@NotNull NameQOM.UniqueKey.$name()@NotNull NameQOM.Call.$procedure()@NotNull NameQOM.CreateProcedure.$procedure()@NotNull NameQOM.DropProcedure.$procedure()@Nullable NameQOM.CreateTrigger.$referencingNewAs()@Nullable NameQOM.CreateTrigger.$referencingOldAs()@Nullable NameQOM.AlterType.$renameTo()default @NotNull NameQOM.XMLPi.$target()@Nullable NameQOM.Rollback.$toSavepoint()@NotNull NameQOM.AlterType.$type()static final @NotNull NameInternal.createPathAlias(Table<?> path, ForeignKey<?, ?> childPath, InverseForeignKey<?, ?> parentPath) Factory method for path aliases.UDTImpl.getQualifiedName()static @NotNull NameCreate a new SQL identifier using an unqualified name.static @NotNull NameCreate a new SQL identifier using a qualified name.static @NotNull NameDSL.name(Collection<String> qualifiedName) Create a new SQL identifier using a qualified name.static @NotNull NameCreate a new SQL identifier using a qualified name.static @NotNull NameDSL.quotedName(String unqualifiedName) Create a new SQL identifier using an unqualified, quoted name.static @NotNull NameDSL.quotedName(String... qualifiedName) Create a new SQL identifier using a qualified, quoted name.static @NotNull NameDSL.quotedName(Collection<String> qualifiedName) Create a new SQL identifier using a qualified, quoted name.static @NotNull NameDSL.systemName(String unqualifiedName) Create a new SQL identifier using an unqualified, quoted name.static @NotNull NameDSL.systemName(String... qualifiedName) Create a new SQL identifier using a qualified, quoted name.static @NotNull NameDSL.systemName(Collection<String> qualifiedName) Create a new SQL identifier using a qualified, system name.static @NotNull NameDSL.unquotedName(String unqualifiedName) Create a new SQL identifier using an unqualified, quoted name.static @NotNull NameDSL.unquotedName(String... qualifiedName) Create a new SQL identifier using a qualified, quoted name.static @NotNull NameDSL.unquotedName(Collection<String> qualifiedName) Create a new SQL identifier using a qualified, quoted name.Methods in org.jooq.impl with parameters of type NameModifier and TypeMethodDescription@NotNull QOM.CreateFunction@NotNull QOM.DropFunction@NotNull Constraint@NotNull Constraint@NotNull Constraint@NotNull QOM.ReleaseSavepoint@NotNull QOM.Savepoint@NotNull QOM.SetCommand@NotNull Constraint@NotNull QOM.CallQOM.Call.$procedure(Name procedure) @NotNull QOM.CreateProcedureQOM.CreateProcedure.$procedure(Name procedure) @NotNull QOM.DropProcedureQOM.DropProcedure.$procedure(Name procedure) @NotNull QOM.CreateTriggerQOM.CreateTrigger.$referencingNewAs(Name referencingNewAs) @NotNull QOM.CreateTriggerQOM.CreateTrigger.$referencingOldAs(Name referencingOldAs) @NotNull QOM.AlterTypedefault @NotNull QOM.XMLPi@NotNull QOM.RollbackQOM.Rollback.$toSavepoint(Name toSavepoint) @NotNull QOM.AlterTypestatic <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 AlterDatabaseStepDSL.alterDatabase(Name database) TheALTER DATABASEstatement.DefaultDSLContext.alterDatabaseIfExists(Name database) static AlterDatabaseStepDSL.alterDatabaseIfExists(Name database) TheALTER DATABASE IF EXISTSstatement.<T> AlterDomainStep<T> DefaultDSLContext.alterDomain(Name domain) static <T> AlterDomainStep<T> DSL.alterDomain(Name domain) TheALTER DOMAINstatement.<T> AlterDomainStep<T> DefaultDSLContext.alterDomainIfExists(Name domain) static <T> AlterDomainStep<T> DSL.alterDomainIfExists(Name domain) TheALTER DOMAIN IF EXISTSstatement.DefaultDSLContext.alterIndex(Name index) static AlterIndexOnStepDSL.alterIndex(Name index) TheALTER INDEXstatement.DefaultDSLContext.alterIndexIfExists(Name index) static AlterIndexOnStepDSL.alterIndexIfExists(Name index) TheALTER INDEX IF EXISTSstatement.DefaultDSLContext.alterMaterializedView(Name view) static AlterViewStepDSL.alterMaterializedView(Name view) TheALTER MATERIALIZED VIEWstatement.DefaultDSLContext.alterMaterializedViewIfExists(Name view) static AlterViewStepDSL.alterMaterializedViewIfExists(Name view) TheALTER MATERIALIZED VIEW IF EXISTSstatement.DefaultDSLContext.alterSchema(Name schema) static AlterSchemaStepDSL.alterSchema(Name schema) TheALTER SCHEMAstatement.DefaultDSLContext.alterSchemaIfExists(Name schema) static AlterSchemaStepDSL.alterSchemaIfExists(Name schema) TheALTER SCHEMA IF EXISTSstatement.DefaultDSLContext.alterSequence(Name sequence) static AlterSequenceStep<Number> DSL.alterSequence(Name sequence) TheALTER SEQUENCEstatement.DefaultDSLContext.alterSequenceIfExists(Name sequence) static AlterSequenceStep<Number> DSL.alterSequenceIfExists(Name sequence) TheALTER SEQUENCE IF EXISTSstatement.DefaultDSLContext.alterTable(Name table) static @NotNull AlterTableStepDSL.alterTable(Name table) Create a new DSLALTER TABLEstatement.DefaultDSLContext.alterTableIfExists(Name table) static @NotNull AlterTableStepDSL.alterTableIfExists(Name table) Create a new DSLALTER TABLEstatement.static AlterTypeStepTheALTER TYPEstatement.DefaultDSLContext.alterTypeIfExists(Name type) static AlterTypeStepDSL.alterTypeIfExists(Name type) TheALTER TYPE IF EXISTSstatement.static AlterViewStepTheALTER VIEWstatement.DefaultDSLContext.alterViewIfExists(Name view) static AlterViewStepDSL.alterViewIfExists(Name view) TheALTER VIEW IF EXISTSstatement.Subclasses may override this method to provide custom aliasing implementationsSubclasses may override this method to provide custom aliasing implementationsstatic CallArgsStepTheCALLstatement.static @NotNull CatalogCreate a qualified catalog, given its catalog name.static @NotNull CharacterSetDSL.characterSet(Name characterSet) Create a character set by its qualified name.static @NotNull CollationCreate a collation by its qualified name.DefaultDSLContext.commentOnColumn(Name field) static CommentOnIsStepDSL.commentOnColumn(Name field) TheCOMMENT ON COLUMNstatement.DefaultDSLContext.commentOnMaterializedView(Name view) static CommentOnIsStepDSL.commentOnMaterializedView(Name view) TheCOMMENT ON MATERIALIZED VIEWstatement.DefaultDSLContext.commentOnTable(Name table) static CommentOnIsStepDSL.commentOnTable(Name table) TheCOMMENT ON TABLEstatement.DefaultDSLContext.commentOnView(Name view) static CommentOnIsStepDSL.commentOnView(Name view) TheCOMMENT ON VIEWstatement.static @NotNull ConstraintTypeStepDSL.constraint(Name name) Create aCONSTRAINTspecification.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 CreateDatabaseFinalStepDSL.createDatabase(Name database) TheCREATE DATABASEstatement.DefaultDSLContext.createDatabaseIfNotExists(Name database) static CreateDatabaseFinalStepDSL.createDatabaseIfNotExists(Name database) TheCREATE DATABASE IF NOT EXISTSstatement.DefaultDSLContext.createDomain(Name domain) static CreateDomainAsStepDSL.createDomain(Name domain) TheCREATE DOMAINstatement.static final <T,U> @NotNull Domain <U> Internal.createDomain(Schema schema, Name name, Comment comment, DataType<T> type, Binding<T, U> binding, Check<?>... checks) Factory method for domain specifications.static final <T> Domain<T> Internal.createDomain(Schema schema, Name name, Comment comment, DataType<T> type, Check<?>... checks) Factory method for domain specifications.static final <T,U> @NotNull Domain <U> Internal.createDomain(Schema schema, Name name, Comment comment, 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, Comment comment, DataType<T> type, Converter<X, U> converter, Binding<T, X> binding, Check<?>... checks) Factory method for domain specifications.static final <T,U> @NotNull Domain <U> Internal.createDomain(Schema schema, Name name, DataType<T> type, Binding<T, U> binding, Check<?>... checks) Deprecated.- 3.20.0 - [#15723] - Regenerate your code.static final <T> @NotNull Domain<T> Internal.createDomain(Schema schema, Name name, DataType<T> type, Check<?>... checks) Deprecated.- 3.20.0 - [#15723] - Regenerate your code.static final <T,U> @NotNull Domain <U> Internal.createDomain(Schema schema, Name name, DataType<T> type, Converter<T, U> converter, Check<?>... checks) Deprecated.- 3.20.0 - [#15723] - Regenerate your code.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) Deprecated.- 3.20.0 - [#15723] - Regenerate your code.DefaultDSLContext.createDomainIfNotExists(Name domain) static CreateDomainAsStepDSL.createDomainIfNotExists(Name domain) TheCREATE DOMAIN IF NOT EXISTSstatement.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<? extends T> type, UDT<R> udt) Subclasses may call this method to createUDTFieldobjects that are linked to this table.UDTImpl.createField(Name name, DataType<? extends T> type, UDT<R> udt, String comment) Subclasses may call this method to createUDTFieldobjects that are linked to this table.UDTImpl.createField(Name name, DataType<? extends T> type, UDT<R> udt, String comment, Binding<T, U> binding) Subclasses may call this method to createUDTFieldobjects that are linked to this table.UDTImpl.createField(Name name, DataType<? extends T> type, UDT<R> udt, String comment, Converter<T, U> converter) Subclasses may call this method to createUDTFieldobjects that are linked to this table.UDTImpl.createField(Name name, DataType<? extends T> type, UDT<R> udt, String comment, Converter<X, U> converter, Binding<T, X> binding) Subclasses may call this method to createUDTFieldobjects 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) Deprecated.- 3.20.0 - [#9736] - Regenerate your code.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, QOM.ForeignKeyRule deleteRule, QOM.ForeignKeyRule updateRule) 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) Deprecated.- 3.20.0 - [#9736] - Regenerate your code.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, QOM.ForeignKeyRule deleteRule, QOM.ForeignKeyRule updateRule) Factory method for foreign keys.DefaultDSLContext.createFunction(Name function) static CreateFunctionParametersStepDSL.createFunction(Name function) TheCREATE FUNCTIONstatement.DefaultDSLContext.createGlobalTemporaryTable(Name table) static CreateTableElementListStepDSL.createGlobalTemporaryTable(Name table) TheCREATE GLOBAL TEMPORARY TABLEstatement.DefaultDSLContext.createGlobalTemporaryTableIfNotExists(Name table) static CreateTableElementListStepDSL.createGlobalTemporaryTableIfNotExists(Name table) TheCREATE GLOBAL TEMPORARY TABLE IF NOT EXISTSstatement.DefaultDSLContext.createIndex(Name index) static CreateIndexStepDSL.createIndex(Name index) TheCREATE INDEXstatement.static final @NotNull IndexInternal.createIndex(Name name, Table<?> table, OrderField<?>[] sortFields, boolean unique) Factory method for indexes.DefaultDSLContext.createIndexIfNotExists(Name index) static CreateIndexStepDSL.createIndexIfNotExists(Name index) TheCREATE INDEX IF NOT EXISTSstatement.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 VIEWstatement.static CreateViewAsStep<Record> DSL.createMaterializedView(Name view, Name... fields) TheCREATE MATERIALIZED VIEWstatement.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 EXISTSstatement.static CreateViewAsStep<Record> DSL.createMaterializedViewIfNotExists(Name view, Name... fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.DefaultDSLContext.createOrReplaceFunction(Name function) static CreateFunctionParametersStepDSL.createOrReplaceFunction(Name function) TheCREATE OR REPLACE FUNCTIONstatement.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 VIEWstatement.static CreateViewAsStep<Record> DSL.createOrReplaceMaterializedView(Name view, Name... fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.DefaultDSLContext.createOrReplaceProcedure(Name procedure) DSL.createOrReplaceProcedure(Name procedure) TheCREATE OR REPLACE PROCEDUREstatement.DefaultDSLContext.createOrReplacePublicSynonym(Name synonym) static CreateSynonymForStepDSL.createOrReplacePublicSynonym(Name synonym) TheCREATE OR REPLACE PUBLIC SYNONYMstatement.DefaultDSLContext.createOrReplaceSynonym(Name synonym) static CreateSynonymForStepDSL.createOrReplaceSynonym(Name synonym) TheCREATE OR REPLACE SYNONYMstatement.DefaultDSLContext.createOrReplaceTrigger(Name trigger) static CreateTriggerEventStepDSL.createOrReplaceTrigger(Name trigger) TheCREATE OR REPLACE TRIGGERstatement.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 VIEWstatement.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 VIEWstatement.DefaultDSLContext.createProcedure(Name procedure) DSL.createProcedure(Name procedure) TheCREATE PROCEDUREstatement.DefaultDSLContext.createPublicSynonym(Name synonym) static CreateSynonymForStepDSL.createPublicSynonym(Name synonym) TheCREATE PUBLIC SYNONYMstatement.DefaultDSLContext.createSchema(Name schema) static CreateSchemaFinalStepDSL.createSchema(Name schema) TheCREATE SCHEMAstatement.DefaultDSLContext.createSchemaIfNotExists(Name schema) static CreateSchemaFinalStepDSL.createSchemaIfNotExists(Name schema) TheCREATE SCHEMA IF NOT EXISTSstatement.DefaultDSLContext.createSequence(Name sequence) static CreateSequenceAsStep<Number> DSL.createSequence(Name sequence) TheCREATE SEQUENCEstatement.DefaultDSLContext.createSequenceIfNotExists(Name sequence) static CreateSequenceAsStep<Number> DSL.createSequenceIfNotExists(Name sequence) TheCREATE SEQUENCE IF NOT EXISTSstatement.DefaultDSLContext.createSynonym(Name synonym) static CreateSynonymForStepDSL.createSynonym(Name synonym) TheCREATE SYNONYMstatement.static final @NotNull SynonymInternal.createSynonym(Schema schema, Name name, Table<?> table, boolean isPublic, Comment comment) Factory method for synonym specifications.DefaultDSLContext.createTable(Name table) static CreateTableElementListStepDSL.createTable(Name table) TheCREATE TABLEstatement.DefaultDSLContext.createTableIfNotExists(Name table) static CreateTableElementListStepDSL.createTableIfNotExists(Name table) TheCREATE TABLE IF NOT EXISTSstatement.DefaultDSLContext.createTemporaryTable(Name table) static CreateTableElementListStepDSL.createTemporaryTable(Name table) TheCREATE TEMPORARY TABLEstatement.DefaultDSLContext.createTemporaryTableIfNotExists(Name table) static CreateTableElementListStepDSL.createTemporaryTableIfNotExists(Name table) TheCREATE TEMPORARY TABLE IF NOT EXISTSstatement.DefaultDSLContext.createTrigger(Name trigger) static CreateTriggerEventStepDSL.createTrigger(Name trigger) TheCREATE TRIGGERstatement.static final @NotNull TriggerInternal.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 CreateTypeStepDSL.createType(Name type) TheCREATE TYPEstatement.DefaultDSLContext.createTypeIfNotExists(Name type) static CreateTypeStepDSL.createTypeIfNotExists(Name type) TheCREATE TYPE IF NOT EXISTSstatement.static final <T,P extends UDTField<?, T>>
PInternal.createUDTPathField(Name name, DataType<? extends T> type, UDTPathField<?, ?, ?> qualifier, Class<P> returnType) static final <T,P extends UDTField<?, T>>
PInternal.createUDTPathField(Name name, DataType<? extends T> type, UDTPathField<?, ?, ?> qualifier, String comment, Class<P> returnType) static final <T,U, P extends UDTField<?, U>>
PInternal.createUDTPathField(Name name, DataType<? extends 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<? extends 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<? extends 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<? extends T> type, Table<R> table, Class<P> returnType) static final <R extends Record,T, P extends UDTPathTableField<R, ?, T>>
PInternal.createUDTPathTableField(Name name, DataType<? extends 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<? extends 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<? extends 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<? extends 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<? extends 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<? extends 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<? extends 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<? extends T> type, TR table, String comment, Class<P> returnType, Generator<R, TR, T> generator) DefaultDSLContext.createUniqueIndex(Name index) static CreateIndexStepDSL.createUniqueIndex(Name index) TheCREATE UNIQUE INDEXstatement.DefaultDSLContext.createUniqueIndexIfNotExists(Name index) static CreateIndexStepDSL.createUniqueIndexIfNotExists(Name index) TheCREATE UNIQUE INDEX IF NOT EXISTSstatement.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 VIEWstatement.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 VIEWstatement.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 EXISTSstatement.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 EXISTSstatement.static @NotNull Domain<?> Create aDOMAINreference.static <T> @NotNull Domain<T> Create aDOMAINreference.static <T> @NotNull Domain<T> Create aDOMAINreference.DefaultDSLContext.dropDatabase(Name database) static DropDatabaseFinalStepDSL.dropDatabase(Name database) TheDROP DATABASEstatement.DefaultDSLContext.dropDatabaseIfExists(Name database) static DropDatabaseFinalStepDSL.dropDatabaseIfExists(Name database) TheDROP DATABASE IF EXISTSstatement.DefaultDSLContext.dropDomain(Name domain) static DropDomainCascadeStepDSL.dropDomain(Name domain) TheDROP DOMAINstatement.DefaultDSLContext.dropDomainIfExists(Name domain) static DropDomainCascadeStepDSL.dropDomainIfExists(Name domain) TheDROP DOMAIN IF EXISTSstatement.DefaultDSLContext.dropFunction(Name function) static DDLQueryDSL.dropFunction(Name function) TheDROP FUNCTIONstatement.DefaultDSLContext.dropFunctionIfExists(Name function) static DDLQueryDSL.dropFunctionIfExists(Name function) TheDROP FUNCTION IF EXISTSstatement.static DropIndexOnStepTheDROP INDEXstatement.DefaultDSLContext.dropIndexIfExists(Name index) static DropIndexOnStepDSL.dropIndexIfExists(Name index) TheDROP INDEX IF EXISTSstatement.DefaultDSLContext.dropMaterializedView(Name view) static DropViewFinalStepDSL.dropMaterializedView(Name view) TheDROP MATERIALIZED VIEWstatement.DefaultDSLContext.dropMaterializedViewIfExists(Name view) static DropViewFinalStepDSL.dropMaterializedViewIfExists(Name view) TheDROP MATERIALIZED VIEW IF EXISTSstatement.DefaultDSLContext.dropProcedure(Name procedure) static DDLQueryDSL.dropProcedure(Name procedure) TheDROP PROCEDUREstatement.DefaultDSLContext.dropProcedureIfExists(Name procedure) static DDLQueryDSL.dropProcedureIfExists(Name procedure) TheDROP PROCEDURE IF EXISTSstatement.DefaultDSLContext.dropPublicSynonym(Name synonym) static DDLQueryDSL.dropPublicSynonym(Name synonym) TheDROP PUBLIC SYNONYMstatement.DefaultDSLContext.dropPublicSynonymIfExists(Name synonym) static DDLQueryDSL.dropPublicSynonymIfExists(Name synonym) TheDROP PUBLIC SYNONYM IF EXISTSstatement.DefaultDSLContext.dropSchema(Name schema) static DropSchemaStepDSL.dropSchema(Name schema) TheDROP SCHEMAstatement.DefaultDSLContext.dropSchemaIfExists(Name schema) static DropSchemaStepDSL.dropSchemaIfExists(Name schema) TheDROP SCHEMA IF EXISTSstatement.DefaultDSLContext.dropSequence(Name sequence) static DropSequenceFinalStepDSL.dropSequence(Name sequence) TheDROP SEQUENCEstatement.DefaultDSLContext.dropSequenceIfExists(Name sequence) static DropSequenceFinalStepDSL.dropSequenceIfExists(Name sequence) TheDROP SEQUENCE IF EXISTSstatement.DefaultDSLContext.dropSynonym(Name synonym) static DDLQueryDSL.dropSynonym(Name synonym) TheDROP SYNONYMstatement.DefaultDSLContext.dropSynonymIfExists(Name synonym) static DDLQueryDSL.dropSynonymIfExists(Name synonym) TheDROP SYNONYM IF EXISTSstatement.static DropTableStepTheDROP TABLEstatement.DefaultDSLContext.dropTableIfExists(Name table) static DropTableStepDSL.dropTableIfExists(Name table) TheDROP TABLE IF EXISTSstatement.DefaultDSLContext.dropTemporaryTable(Name table) static DropTableStepDSL.dropTemporaryTable(Name table) TheDROP TEMPORARY TABLEstatement.DefaultDSLContext.dropTemporaryTableIfExists(Name table) static DropTableStepDSL.dropTemporaryTableIfExists(Name table) TheDROP TEMPORARY TABLE IF EXISTSstatement.DefaultDSLContext.dropTrigger(Name trigger) static DropTriggerOnStepDSL.dropTrigger(Name trigger) TheDROP TRIGGERstatement.DefaultDSLContext.dropTriggerIfExists(Name trigger) static DropTriggerOnStepDSL.dropTriggerIfExists(Name trigger) TheDROP TRIGGER IF EXISTSstatement.static DropTypeStepTheDROP TYPEstatement.static DropTypeStepTheDROP TYPEstatement.DefaultDSLContext.dropTypeIfExists(Name types) DefaultDSLContext.dropTypeIfExists(Name... types) static DropTypeStepDSL.dropTypeIfExists(Name types) TheDROP TYPE IF EXISTSstatement.static DropTypeStepDSL.dropTypeIfExists(Name... types) TheDROP TYPE IF EXISTSstatement.static DropViewFinalStepTheDROP VIEWstatement.DefaultDSLContext.dropViewIfExists(Name view) static DropViewFinalStepDSL.dropViewIfExists(Name view) TheDROP VIEW IF EXISTSstatement.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 KEYclause to theCONSTRAINT.static @NotNull ConstraintForeignKeyReferencesStepNDSL.foreignKey(Name... fields) Add aFOREIGN KEYclause to theCONSTRAINT.static @NotNull ConstraintForeignKeyReferencesStep2<?, ?> DSL.foreignKey(Name field1, Name field2) Add an unnamed (system named)FOREIGN KEYclause to theCONSTRAINT.static @NotNull ConstraintForeignKeyReferencesStep3<?, ?, ?> DSL.foreignKey(Name field1, Name field2, Name field3) Add an unnamed (system named)FOREIGN KEYclause to theCONSTRAINT.static @NotNull ConstraintForeignKeyReferencesStep4<?, ?, ?, ?> DSL.foreignKey(Name field1, Name field2, Name field3, Name field4) Add an unnamed (system named)FOREIGN KEYclause to theCONSTRAINT.static @NotNull ConstraintForeignKeyReferencesStep5<?, ?, ?, ?, ?> Add an unnamed (system named)FOREIGN KEYclause to theCONSTRAINT.static @NotNull ConstraintForeignKeyReferencesStep6<?, ?, ?, ?, ?, ?> Add an unnamed (system named)FOREIGN KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause 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 KEYclause to theCONSTRAINT.static <T> @NotNull Field<T> DSL.function(Name name, Class<T> type, Collection<? extends Field<?>> arguments) 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.static <T> @NotNull Field<T> DSL.function(Name name, DataType<T> type, Collection<? extends Field<?>> arguments) 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 Schemafinal Schemafinal Sequence<?> LazySchema.getSequence(Name name) final Sequence<?> SchemaImpl.getSequence(Name name) final SynonymLazySchema.getSynonym(Name name) final SynonymSchemaImpl.getSynonym(Name name) final Table<?> final Table<?> final TriggerLazySchema.getTrigger(Name name) final TriggerSchemaImpl.getTrigger(Name name) final UDT<?> final UDT<?> LazySchema.getUniqueKeys(Name name) SchemaImpl.getUniqueKeys(Name name) static <T> @NotNull Parameter<T> Create anINparameter.static @NotNull IndexCreate a qualified index reference by name.static <T> @NotNull Parameter<T> Create anIN OUTparameter.static @NotNull LabelCreate a label reference for use in procedural code.static @NotNull LinkCreate a database link reference.static @NotNull NameCreate a new SQL identifier using a qualified name.static final <T> CustomField<T> Create aCustomFieldfrom a lambda expression.static <T> @NotNull Parameter<T> Create anOUTparameter.Create a namedPeriodreference.static <T> @NotNull Period<T> Create a namedPeriodreference.static <T> @NotNull Period<T> Create a namedPeriodreference.static @NotNull ConstraintEnforcementStepDSL.primaryKey(Name... fields) Create an unnamed (system named)PRIMARY KEYconstraint.DefaultDSLContext.releaseSavepoint(Name name) static RowCountQueryDSL.releaseSavepoint(Name name) TheRELEASE SAVEPOINTstatement.static @NotNull RoleCreate a new role reference.static RowCountQueryTheSAVEPOINTstatement.static @NotNull SchemaCreate 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 RowCountQueryTheSETstatement.DefaultDSLContext.setCatalog(Name catalog) static RowCountQueryDSL.setCatalog(Name catalog) TheSET CATALOGstatement.static RowCountQueryTheSET LOCALstatement.static RowCountQueryTheSET SCHEMAstatement.static @NotNull SynonymCreate a qualified type, given its type name.Create a qualified table, given its table name.Create a qualified table, given its table name.static @NotNull TriggerCreate a qualified trigger reference by name.static TruncateIdentityStep<Record> TheTRUNCATEstatement.static TruncateIdentityStep<Record> TheTRUNCATEstatement.DefaultDSLContext.truncateTable(Name table) DefaultDSLContext.truncateTable(Name... table) static TruncateIdentityStep<Record> DSL.truncateTable(Name table) TheTRUNCATE TABLEstatement.static TruncateIdentityStep<Record> DSL.truncateTable(Name... table) TheTRUNCATE TABLEstatement.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 ConstraintEnforcementStepCreate an unnamed (system named)UNIQUEconstraint.static @NotNull UserCreate 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, wherevaris 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 WithAsStepCreate aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStepDSL.with(Name alias, Collection<? extends Name> fieldAliases) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep1Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStepCreate aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep2Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep3Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep4Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep5DSL.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep6DSL.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep7DSL.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep8DSL.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep9DSL.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep10DSL.with(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep11DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep12DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep13DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep14DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep15DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep16DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep17DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep18DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep19DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep20DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep21DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep22DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.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 WithAsStepDSL.withRecursive(Name alias) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStepDSL.withRecursive(Name alias, Collection<? extends Name> fieldAliases) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep1DSL.withRecursive(Name alias, Name fieldAlias1) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStepDSL.withRecursive(Name alias, Name... fieldAliases) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep2DSL.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep3DSL.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep4DSL.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep5DSL.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep6DSL.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep7DSL.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep8DSL.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep9DSL.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep10DSL.withRecursive(Name alias, Name fieldAlias1, Name fieldAlias2, Name fieldAlias3, Name fieldAlias4, Name fieldAlias5, Name fieldAlias6, Name fieldAlias7, Name fieldAlias8, Name fieldAlias9, Name fieldAlias10) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep11DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep12DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep13DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep14DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep15DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep16DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep17DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep18DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep19DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep20DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep21DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.static @NotNull WithAsStep22DSL.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 aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.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.TheXMLPIfunction.TheXMLPIfunction.Method parameters in org.jooq.impl with type arguments of type NameModifier and TypeMethodDescriptionDefaultDSLContext.createMaterializedView(Name view, Collection<? extends Name> fields) static CreateViewAsStep<Record> DSL.createMaterializedView(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEWstatement.DefaultDSLContext.createMaterializedViewIfNotExists(Name view, Collection<? extends Name> fields) static CreateViewAsStep<Record> DSL.createMaterializedViewIfNotExists(Name view, Collection<? extends Name> fields) TheCREATE MATERIALIZED VIEW IF NOT EXISTSstatement.DefaultDSLContext.createOrReplaceMaterializedView(Name view, Collection<? extends Name> fields) static CreateViewAsStep<Record> DSL.createOrReplaceMaterializedView(Name view, Collection<? extends Name> fields) TheCREATE OR REPLACE MATERIALIZED VIEWstatement.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 VIEWstatement.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 VIEWstatement.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 EXISTSstatement.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 WithAsStepDSL.with(Name alias, Collection<? extends Name> fieldAliases) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.DefaultDSLContext.withRecursive(Name alias, Collection<? extends Name> fieldAliases) static @NotNull WithAsStepDSL.withRecursive(Name alias, Collection<? extends Name> fieldAliases) Create aWITHclause to supply subsequentSELECT,UPDATE,INSERT,DELETE, andMERGEstatements withCommonTableExpressions.Constructors in org.jooq.impl with parameters of type NameModifierConstructorDescriptionCatalogImpl(Name name) CatalogImpl(Name name, Comment comment) protectedCustomField(Name name, DataType<T> type) protectedCustomTable(Name name) protectedCustomTable(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)