Name (jOOQ 3.11.12 API)

All Superinterfaces:

QueryPart, Serializable
```
public interface Name
extends QueryPart
```
A SQL identifier QueryPart.
A Name is a QueryPart that renders a SQL identifier according to the settings specified in Settings.getRenderNameStyle().

Author:

Lukas Eder

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`Name`	`append(Name name)` Appends `name` (all of its `parts()`) to this name.
`Name`	`append(String name)` Appends `name` to this name.
`WindowDefinition`	`as()` Create an empty `WindowDefinition` from this name.
`<R extends Record> CommonTableExpression<R>`	`as(Select<R> select)` Specify a subselect to refer to by the `Name` to form a common table expression.
`WindowDefinition`	`as(WindowSpecification window)` Create a `WindowDefinition` from this 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.
`DerivedColumnList`	`fields(BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)` Add a list of fields to this name to make this name a `DerivedColumnList`.
`DerivedColumnList`	`fields(Function<? super Field<?>,? extends String> fieldNameFunction)` Add a list of fields to this name to make this name a `DerivedColumnList`.
`DerivedColumnList`	`fields(Name... fieldNames)` Add a list of fields to this name to make this name a `DerivedColumnList`.
`DerivedColumnList1`	`fields(Name fieldName1)` Add a list of fields to this name to make this name a `DerivedColumnList`.
`DerivedColumnList2`	`fields(Name fieldName1, Name fieldName2)` Add a list of fields to this name to make this name a `DerivedColumnList`.
`DerivedColumnList3`	`fields(Name fieldName1, Name fieldName2, Name fieldName3)` Add a list of fields to this name to make this name a `DerivedColumnList`.
`DerivedColumnList4`	`fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4)` Add a list of fields to this name to make this name a `DerivedColumnList`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`DerivedColumnList`	`fields(String... fieldNames)` Add a list of fields to this name to make this name a `DerivedColumnList`.
`DerivedColumnList1`	`fields(String fieldName1)` Add a list of fields to this name to make this name a `DerivedColumnList`.
`DerivedColumnList2`	`fields(String fieldName1, String fieldName2)` Add a list of fields to this name to make this name a `DerivedColumnList`.
`DerivedColumnList3`	`fields(String fieldName1, String fieldName2, String fieldName3)` Add a list of fields to this name to make this name a `DerivedColumnList`.
`DerivedColumnList4`	`fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4)` Add a list of fields to this name to make this name a `DerivedColumnList`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`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`.
`String`	`first()` Get the first segment of the qualified name (usually a `Catalog` or `Schema` name).
`String[]`	`getName()` The qualified name of this SQL identifier.
`String`	`last()` Get the last segment of the qualified name (usually a `Table`, `Field`, or `Parameter` name).
`Name[]`	`parts()` Get the individual, unqualified name parts of this name.
`boolean`	`qualified()` Whether this is a qualified name.
`Name`	`qualifier()` This name's qualifier (if it is `qualified()`), or `null`.
`Name`	`quotedName()` This name, quoted.
`Name`	`unqualifiedName()` This name, unqualified.
`Name`	`unquotedName()` This name, unquoted.

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

Method Detail

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

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

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

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

unqualifiedName
```
Name unqualifiedName()
```
This name, unqualified.

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

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

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

append
```
Name append(String name)
```
Appends name to this name.

append
```
Name append(Name name)
```
Appends name (all of its parts()) to this name.

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

as

@Support(value={AURORA_POSTGRES,CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
WindowDefinition as()

Create an empty WindowDefinition from this name.

See Also:: as(WindowSpecification)

as
```
@Support(value={AURORA_POSTGRES,CUBRID,DB2,FIREBIRD_3_0,HANA,INFORMIX,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
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

@Support(value={AURORA_POSTGRES,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
<R extends Record> 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.

fields
```
@Support(value={AURORA_POSTGRES,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
DerivedColumnList fields(String... fieldNames)
```
Add a list of fields to this name to make this name a DerivedColumnList.
The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.

fields
```
@Support(value={AURORA_POSTGRES,DB2,FIREBIRD,H2,HSQLDB,MARIADB,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
DerivedColumnList fields(Name... fieldNames)
```
Add a list of fields to this name to make this name a DerivedColumnList.
The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.

fields
```
@Support(value={AURORA_POSTGRES,DB2,FIREBIRD,H2,HSQLDB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
DerivedColumnList fields(Function<? super Field<?>,? extends String> fieldNameFunction)
```
Add a list of fields to this name to make this name a DerivedColumnList.
The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
This works in a similar way as fields(String...), except that all column names are produced by a function that receives the CTE's Select columns and their column indexes as input.

fields
```
@Support(value={AURORA_POSTGRES,DB2,FIREBIRD,H2,HSQLDB,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
DerivedColumnList fields(BiFunction<? super Field<?>,? super Integer,? extends String> fieldNameFunction)
```
Add a list of fields to this name to make this name a DerivedColumnList.
The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
This works in a similar way as fields(String...), except that all column names are produced by a function that receives the CTE's Select columns as input.