All Superinterfaces:

Comparable<Name>, QueryPart, Serializable
```
public interface Name
extends QueryPart, Comparable<Name>
```
An identifier.
A Name or identifier is a QueryPart that renders a SQL identifier according to the settings specified in Settings.getRenderQuotedNames() and Settings.getRenderNameCase().
Example:
```
 // Assuming import static org.jooq.impl.DSL.*;

 using(configuration)
    .select(
         field(name("FIRST_NAME"), SQLDataType.VARCHAR),
         field(name("LAST_NAME"), SQLDataType.VARCHAR))
    .from(table(name("ACTOR")))
    .fetch();
 
```
Instances can be created using DSL.name(String) and overloads.
Author:

Lukas Eder

Nested Class Summary

Nested Classes
Modifier and Type Interface Description

static class Name.Quoted
A flag indicating whether the name is quoted or not.

Method Summary

All Methods Instance Methods Abstract Methods Deprecated Methods
Modifier and Type	Method	Description
`@NotNull Name`	`append(String name)`	Appends `name` to this name.
`@NotNull Name`	`append(Name name)`	Appends `name` (all of its `parts()`) to this name.
`@NotNull WindowDefinition`	`as()`	Create an empty `WindowDefinition` from this name.
`<R extends Record> @NotNull CommonTableExpression<R>`	`as(Select<R> select)`	Specify a subselect to refer to by the `Name` to form a common table expression.
`@NotNull WindowDefinition`	`as(WindowSpecification window)`	Create a `WindowDefinition` from this name.
`<R extends Record> @NotNull CommonTableExpression<R>`	`asMaterialized(Select<R> select)`	Specify a materialized subselect to refer to by the `Name` to form a common table expression.
`<R extends Record> @NotNull CommonTableExpression<R>`	`asNotMaterialized(Select<R> select)`	Specify a non-materialized subselect to refer to by the `Name` to form a common table expression.
`int`	`compareTo(Name o)`	Compare two `unquotedName()` by their qualified string versions.
`boolean`	`empty()`	Whether this is the empty name.
`boolean`	`equals(Object other)`	Check whether this `QueryPart` can be considered equal to another `QueryPart`.
`boolean`	`equalsIgnoreCase(Name other)`	Compare this name with another one ignoring case.
`@NotNull DerivedColumnList1`	`fields(String fieldName1)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList`	`fields(String... fieldNames)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList2`	`fields(String fieldName1, String fieldName2)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList3`	`fields(String fieldName1, String fieldName2, String fieldName3)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList4`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList5`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList6`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList7`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList8`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList9`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList10`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList11`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList12`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList13`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList14`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList15`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList16`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList17`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList18`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList19`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18, String fieldName19)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList20`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18, String fieldName19, String fieldName20)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList21`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18, String fieldName19, String fieldName20, String fieldName21)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList22`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18, String fieldName19, String fieldName20, String fieldName21, String fieldName22)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList`	`fields(BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)`	Deprecated. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
`@NotNull DerivedColumnList`	`fields(Function<? super Field<?>,? extends String> fieldNameFunction)`	Deprecated. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
`@NotNull DerivedColumnList1`	`fields(Name fieldName1)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList`	`fields(Name... fieldNames)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList2`	`fields(Name fieldName1, Name fieldName2)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList3`	`fields(Name fieldName1, Name fieldName2, Name fieldName3)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList4`	`fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList5`	`fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5)`	Add a list of fields to this name to make this name a `DerivedColumnList`.
`@NotNull DerivedColumnList6`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList7`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList8`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList9`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList10`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList11`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList12`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList13`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList14`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList15`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList16`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList17`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList18`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList19`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList20`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList21`	`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 a `DerivedColumnList`.
`@NotNull DerivedColumnList22`	`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 a `DerivedColumnList`.
`@Nullable String`	`first()`	Get the first segment of the qualified name (usually a `Catalog` or `Schema` name).
`@NotNull String[]`	`getName()`	The qualified name of this SQL identifier.
`@Nullable String`	`last()`	Get the last segment of the qualified name (usually a `Table`, `Field`, or `Parameter` name).
`@NotNull Name[]`	`parts()`	Get the individual, unqualified name parts of this name.
`boolean`	`qualified()`	Whether this is a qualified name.
`@Nullable Name`	`qualifier()`	This name's qualifier (if it is `qualified()`), or `null`.
`boolean`	`qualifierQualified()`	Whether this is a qualified name and the `qualifier()` is also a qualified name.
`@NotNull Name.Quoted`	`quoted()`	Whether this is a quoted name.
`@NotNull Name`	`quotedName()`	This name, quoted.
`@NotNull Name`	`unqualifiedName()`	This name, unqualified.
`@NotNull Name`	`unquotedName()`	This name, unquoted.

Methods inherited from interface org.jooq.QueryPart
hashCode, toString

Method Detail

first
```
@Nullable
@Nullable String first()
```
Get the first segment of the qualified name (usually a Catalog or Schema name).

last
```
@Nullable
@Nullable String last()
```
Get the last segment of the qualified name (usually a Table, Field, or Parameter name).

empty
```
boolean empty()
```
Whether this is the empty name.
An unnamed object will have an "" empty string as its name. If a table has no explicit schema, it will be located in the default schema whose name is "".

qualified
```
boolean qualified()
```
Whether this is a qualified name.
This is true as soon as getName() has a length of more than 1 and qualifier() is not null.

qualifierQualified
```
boolean qualifierQualified()
```
Whether this is a qualified name and the qualifier() is also a qualified name.
This is true as soon as getName() has a length of more than 2 and qualifier() is not null and its qualified() property is also true.

qualifier
```
@Nullable
@Nullable Name qualifier()
```
This name's qualifier (if it is qualified()), or null.

unqualifiedName

@NotNull
@NotNull Name unqualifiedName()

This name, unqualified.

quoted
```
@NotNull
@NotNull Name.Quoted quoted()
```
Whether this is a quoted name.

quotedName
```
@NotNull
@NotNull Name quotedName()
```
This name, quoted.

unquotedName
```
@NotNull
@NotNull Name unquotedName()
```
This name, unquoted.

parts
```
@NotNull
@NotNull Name[] parts()
```
Get the individual, unqualified name parts of this name.

append

@NotNull
@NotNull Name append(String name)

Appends name to this name.

append

@NotNull
@NotNull Name append(Name name)

Appends name (all of its parts()) to this name.

getName
```
@NotNull
@NotNull String[] getName()
```
The qualified name of this SQL identifier.

as

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull WindowDefinition as()

Create an empty WindowDefinition from this name.

See Also:: as(WindowSpecification)

as

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA})
@NotNull WindowDefinition as(WindowSpecification window)

Create a WindowDefinition from this name.

This creates a window definition that can be

declared in the WINDOW clause (see SelectWindowStep.window(WindowDefinition...)
referenced from the OVER clause (see WindowOverStep.over(WindowDefinition)

as

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<R extends Record> @NotNull CommonTableExpression<R> as(Select<R> select)

Specify a subselect to refer to by the Name to form a common table expression.

Column names are implicitly inherited from the SELECT statement.

asMaterialized
```
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<R extends Record> @NotNull CommonTableExpression<R> asMaterialized(Select<R> select)
```
Specify a materialized subselect to refer to by the Name to form a common table expression.
This adds the PostgreSQL 12 MATERIALIZED hint to the common table expression definition, or silently ignores it, if the hint is not supported.
Column names are implicitly inherited from the SELECT statement.

asNotMaterialized
```
@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<R extends Record> @NotNull CommonTableExpression<R> asNotMaterialized(Select<R> select)
```
Specify a non-materialized subselect to refer to by the Name to form a common table expression.
This adds the PostgreSQL 12 NOT MATERIALIZED hint to the common table expression definition, or silently ignores it, if the hint is not supported.
Column names are implicitly inherited from the SELECT statement.