Deprecated
as a consequence of CreateIndexIncludeStep, CreateIndexWhereStep and CreateIndexFinalStep being deprecated. See corresponding docs for further information.
CREATE INDEX statement.
| Modifier and Type | Field and Description |
|---|---|
| private static final Clause[] | |
| pack-priv boolean | |
| pack-priv final boolean | |
| pack-priv QueryPartListView | |
| pack-priv final Index | |
| private static final Set | |
| private static final Set | |
| pack-priv QueryPartListView | |
| private static final Set | |
| private static final Set | |
| private static final Set | |
| pack-priv Table | |
| pack-priv final boolean | |
| pack-priv Condition |
| Access | Constructor and Description |
|---|---|
| pack-priv | |
| pack-priv | |
| pack-priv | CreateIndexImpl(Configuration configuration, boolean unique, Index index, boolean ifNotExists, Table<?> table, Collection<? extends OrderField<?>> on, Collection<? extends Field<?>> include, Condition where, boolean excludeNullKeys)
Deprecated
as a consequence of
Condition being deprecated.
|
| Modifier and Type | Method and Description |
|---|---|
| public final Function8 | |
| public final boolean | |
| public final QOM. | |
| public final boolean | |
| public final QOM. | |
| public final QOM. | |
| public final QOM. | |
| public final Index | |
| public final QOM. | |
| public final QOM. | |
| public final QOM. | |
| public final Table | |
| public final QOM. | |
| public final boolean | |
| public final QOM. | |
| public final Condition | $where()
Implements org.
Deprecated
as a consequence of
Condition being deprecated.
|
| public final QOM. | $where(Condition newValue)
Implements org.
Deprecated
as a consequence of
Condition being deprecated.
|
| public final void | accept(Context<?> ctx)
Implements org. QueryPart can accept a Context object
in order to render a SQL string or to bind its variables.
|
| private final void | |
| public final Clause[] | clauses(Context<?> ctx)
Overrides org. Implements org.
Deprecated
as a consequence of
The Clause being deprecated.
Clauses that are represented by this query part.
|
| public final CreateIndexImpl | excludeNullKeys()
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
EXCLUDE NULL KEYS clause to the CREATE INDEX statement.
|
| private final Name | |
| public final CreateIndexImpl | include(String... include)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
INCLUDE clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | include(Name... include)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
INCLUDE clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | include(Field<?>... include)
Implements org.
Deprecated
as a consequence of
Add the Field and CreateIndexImpl being deprecated.
INCLUDE clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | include(Collection<? extends Field<?>> include)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
INCLUDE clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | on(String table, String... on)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
ON clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | on(Name table, Name... on)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
ON clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | on(Table<?> table, OrderField<?>... on)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
ON clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | on(String table, Collection<? extends String> on)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
ON clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | on(Name table, Collection<? extends Name> on)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
ON clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | on(Table<?> table, Collection<? extends OrderField<?>> on)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
ON clause to the CREATE INDEX statement.
|
| private final boolean | |
| public final CreateIndexImpl | where(Field<Boolean> where)
Implements org.
Deprecated
as a consequence of
Add the Field and CreateIndexImpl being deprecated.
WHERE clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | where(Condition... where)
Implements org.
Deprecated
as a consequence of
Add the Condition and CreateIndexImpl being deprecated.
WHERE clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | where(Collection<? extends Condition> where)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
WHERE clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | where(Condition where)
Implements org.
Deprecated
as a consequence of
Add the Condition and CreateIndexImpl being deprecated.
WHERE clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | where(String where, QueryPart... parts)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
WHERE clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | where(String where, Object... bindings)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
WHERE clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | where(String where)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
WHERE clause to the CREATE INDEX statement.
|
| public final CreateIndexImpl | where(SQL where)
Implements org.
Deprecated
as a consequence of
Add the CreateIndexImpl being deprecated.
WHERE clause to the CREATE INDEX statement.
|
| CLAUSES | back to summary |
|---|---|
| private static final Clause[] CLAUSES
Deprecated as a consequence of | |
| excludeNullKeys | back to summary |
|---|---|
| pack-priv boolean excludeNullKeys | |
| ifNotExists | back to summary |
|---|---|
| pack-priv final boolean ifNotExists | |
| include | back to summary |
|---|---|
| pack-priv QueryPartListView<? extends Field<?>> include | |
| index | back to summary |
|---|---|
| pack-priv final Index index | |
| NO_SUPPORT_IF_NOT_EXISTS | back to summary |
|---|---|
| private static final Set<SQLDialect> NO_SUPPORT_IF_NOT_EXISTS | |
| NO_SUPPORT_SORT_SPEC | back to summary |
|---|---|
| private static final Set<SQLDialect> NO_SUPPORT_SORT_SPEC | |
| on | back to summary |
|---|---|
| pack-priv QueryPartListView<? extends OrderField<?>> on | |
| SUPPORT_INCLUDE | back to summary |
|---|---|
| private static final Set<SQLDialect> SUPPORT_INCLUDE | |
| SUPPORT_UNIQUE_INCLUDE | back to summary |
|---|---|
| private static final Set<SQLDialect> SUPPORT_UNIQUE_INCLUDE | |
| SUPPORT_UNNAMED_INDEX | back to summary |
|---|---|
| private static final Set<SQLDialect> SUPPORT_UNNAMED_INDEX | |
| table | back to summary |
|---|---|
| pack-priv Table<?> table | |
| unique | back to summary |
|---|---|
| pack-priv final boolean unique | |
| where | back to summary |
|---|---|
| pack-priv Condition where
Deprecated as a consequence of | |
| CreateIndexImpl | back to summary |
|---|---|
| pack-priv CreateIndexImpl(Configuration configuration, boolean unique, Index index, boolean ifNotExists) | |
| CreateIndexImpl | back to summary |
|---|---|
| pack-priv CreateIndexImpl(Configuration configuration, boolean unique, boolean ifNotExists) | |
| CreateIndexImpl | back to summary |
|---|---|
| pack-priv CreateIndexImpl(Configuration configuration, boolean unique, Index index, boolean ifNotExists, Table<?> table, Collection<? extends OrderField<?>> on, Collection<? extends Field<?>> include, Condition where, boolean excludeNullKeys)
Deprecated as a consequence of | |
| $constructor | back to summary |
|---|---|
| public final Function8 | |
| $excludeNullKeys | back to summary |
|---|---|
| public final boolean $excludeNullKeys() Implements org.
| |
| $excludeNullKeys | back to summary |
|---|---|
| public final QOM. Implements org.
| |
| $ifNotExists | back to summary |
|---|---|
| public final boolean $ifNotExists() Implements org.
| |
| $ifNotExists | back to summary |
|---|---|
| public final QOM. Implements org.
| |
| $include | back to summary |
|---|---|
| public final QOM. Implements org.
| |
| $include | back to summary |
|---|---|
| public final QOM. Implements org.
| |
| $index | back to summary |
|---|---|
| public final Index $index() Implements org.
| |
| $index | back to summary |
|---|---|
| public final QOM. Implements org.
| |
| $on | back to summary |
|---|---|
| public final QOM. Implements org.
| |
| $on | back to summary |
|---|---|
| public final QOM. Implements org.
| |
| $table | back to summary |
|---|---|
| public final Table Implements org.
| |
| $table | back to summary |
|---|---|
| public final QOM. Implements org.
| |
| $unique | back to summary |
|---|---|
| public final boolean $unique() Implements org.
| |
| $unique | back to summary |
|---|---|
| public final QOM. Implements org.
| |
| $where | back to summary |
|---|---|
| public final Condition $where() Implements org. Deprecated as a consequence of
| |
| $where | back to summary |
|---|---|
| public final QOM. Implements org. Deprecated as a consequence of
| |
| accept | back to summary |
|---|---|
| public final void accept(Context<?> ctx) Implements org. Doc from org. This
| |
| accept0 | back to summary |
|---|---|
| private final void accept0(Context<?> ctx) | |
| clauses | back to summary |
|---|---|
| public final Clause[] clauses(Context<?> ctx) Overrides org. Implements org. Doc from org. Deprecated as a consequence of The
This method is for JOOQ INTERNAL USE only. Do not reference directly | |
| excludeNullKeys | back to summary |
|---|---|
| public final CreateIndexImpl excludeNullKeys() Implements org. Doc from org. Deprecated as a consequence of Add the
| |
| generatedName | back to summary |
|---|---|
| private final Name generatedName() | |
| include | back to summary |
|---|---|
| public final CreateIndexImpl include(String... include) Implements org. Doc from org. Deprecated as a consequence of Add the If this is not supported by any given database, then the included columns will simply be put in the index as ordinary columns, making the index a composite index.
| |
| include | back to summary |
|---|---|
| public final CreateIndexImpl include(Name... include) Implements org. Doc from org. Deprecated as a consequence of Add the If this is not supported by any given database, then the included columns will simply be put in the index as ordinary columns, making the index a composite index.
| |
| include | back to summary |
|---|---|
| public final CreateIndexImpl include(Field<?>... include) Implements org. Doc from org. Deprecated as a consequence of Add the If this is not supported by any given database, then the included columns will simply be put in the index as ordinary columns, making the index a composite index.
| |
| include | back to summary |
|---|---|
| public final CreateIndexImpl include(Collection<? extends Field<?>> include) Implements org. Doc from org. Deprecated as a consequence of Add the If this is not supported by any given database, then the included columns will simply be put in the index as ordinary columns, making the index a composite index.
| |
| on | back to summary |
|---|---|
| public final CreateIndexImpl on(String table, String... on) Implements org. Doc from org. Deprecated as a consequence of Add the
| |
| on | back to summary |
|---|---|
| public final CreateIndexImpl on(Name table, Name... on) Implements org. Doc from org. Deprecated as a consequence of Add the
| |
| on | back to summary |
|---|---|
| public final CreateIndexImpl on(Table<?> table, OrderField<?>... on) Implements org. Doc from org. Deprecated as a consequence of Add the
| |
| on | back to summary |
|---|---|
| public final CreateIndexImpl on(String table, Collection<? extends String> on) Implements org. Doc from org. Deprecated as a consequence of Add the
| |
| on | back to summary |
|---|---|
| public final CreateIndexImpl on(Name table, Collection<? extends Name> on) Implements org. Doc from org. Deprecated as a consequence of Add the
| |
| on | back to summary |
|---|---|
| public final CreateIndexImpl on(Table<?> table, Collection<? extends OrderField<?>> on) Implements org. Doc from org. Deprecated as a consequence of Add the
| |
| supportsIfNotExists | back to summary |
|---|---|
| private final boolean supportsIfNotExists(Context<?> ctx) | |
| where | back to summary |
|---|---|
| public final CreateIndexImpl where(Field<Boolean> where) Implements org. Doc from org. Deprecated as a consequence of Add the
| |
| where | back to summary |
|---|---|
| public final CreateIndexImpl where(Condition... where) Implements org. Doc from org. Deprecated as a consequence of Add the
| |
| where | back to summary |
|---|---|
| public final CreateIndexImpl where(Collection<? extends Condition> where) Implements org. Doc from org. Deprecated as a consequence of Add the
| |
| where | back to summary |
|---|---|
| public final CreateIndexImpl where(Condition where) Implements org. Doc from org. Deprecated as a consequence of Add the
| |
| where | back to summary |
|---|---|
| public final CreateIndexImpl where(String where, QueryPart... parts) Implements org. Doc from org. Deprecated as a consequence of Add the Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
| |
| where | back to summary |
|---|---|
| public final CreateIndexImpl where(String where, Object... bindings) Implements org. Doc from org. Deprecated as a consequence of Add the Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
| |
| where | back to summary |
|---|---|
| public final CreateIndexImpl where(String where) Implements org. Doc from org. Deprecated as a consequence of Add the Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
| |
| where | back to summary |
|---|---|
| public final CreateIndexImpl where(SQL where) Implements org. Doc from org. Deprecated as a consequence of Add the Note When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity. You may also create the possibility of malicious SQL injection. Be sure to properly use bind variables and/or escape literals when concatenated into SQL clauses!
| |