Module org.jooq

Package org.jooq

Interface CreateTypeStep

public interface CreateTypeStep

A step in the construction of the CREATE TYPE statement.

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

• They're operating on mutable implementations (as of jOOQ 3.x)
• They're less composable and not easy to get right when dynamic SQL gets complex
• They're less readable
• They might have binary incompatible changes between minor releases

Method Summary

Modifier and Type	Method	Description
@NotNull CreateTypeFinalStep	as(Collection<? extends Field<?>> attributes)	Add the AS clause to the CREATE TYPE statement.
@NotNull CreateTypeFinalStep	as(Field<?>... attributes)	Add the AS clause to the CREATE TYPE statement.
@NotNull CreateTypeFinalStep	asEnum()	Add the AS ENUM clause to the CREATE TYPE statement.
@NotNull CreateTypeFinalStep	asEnum(String... values)	Add the AS ENUM clause to the CREATE TYPE statement.
@NotNull CreateTypeFinalStep	asEnum(Collection<? extends Field<String>> values)	Add the AS ENUM clause to the CREATE TYPE statement.
@NotNull CreateTypeFinalStep	asEnum(Field<String>... values)	Add the AS ENUM clause to the CREATE TYPE statement.

Method Details

asEnum

@Support({AURORA_POSTGRES,COCKROACHDB,DUCKDB,H2,POSTGRES,YUGABYTEDB})
@NotNull
@CheckReturnValue
@NotNull CreateTypeFinalStep asEnum(@Param
 String... values)

Add the AS ENUM clause to the CREATE TYPE statement.

asEnum

@Support({AURORA_POSTGRES,COCKROACHDB,DUCKDB,H2,POSTGRES,YUGABYTEDB})
@NotNull
@CheckReturnValue
@NotNull CreateTypeFinalStep asEnum(Field<String>... values)

Add the AS ENUM clause to the CREATE TYPE statement.

asEnum

@Support({AURORA_POSTGRES,COCKROACHDB,DUCKDB,H2,POSTGRES,YUGABYTEDB})
@NotNull
@CheckReturnValue
@NotNull CreateTypeFinalStep asEnum(Collection<? extends Field<String>> values)

Add the AS ENUM clause to the CREATE TYPE statement.

asEnum

@Support({AURORA_POSTGRES,COCKROACHDB,DUCKDB,H2,POSTGRES,YUGABYTEDB})
@NotNull
@CheckReturnValue
@NotNull CreateTypeFinalStep asEnum()

Add the AS ENUM clause to the CREATE TYPE statement.

as

@Support({AURORA_POSTGRES,COCKROACHDB,DUCKDB,INFORMIX,ORACLE,POSTGRES,YUGABYTEDB})
@NotNull
@CheckReturnValue
@NotNull CreateTypeFinalStep as(Field<?>... attributes)

Add the AS clause to the CREATE TYPE statement.

as

@Support({AURORA_POSTGRES,COCKROACHDB,DUCKDB,INFORMIX,ORACLE,POSTGRES,YUGABYTEDB})
@NotNull
@CheckReturnValue
@NotNull CreateTypeFinalStep as(Collection<? extends Field<?>> attributes)

Add the AS clause to the CREATE TYPE statement.