Package org.jooq

Interface Name

  • All Superinterfaces:
    QueryPart, java.io.Serializable

    public interface Name
    extends QueryPart
    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 
      Modifier and Type Method Description
      Name append​(java.lang.String name)
      Appends name to this name.
      Name append​(Name name)
      Appends name (all of its parts()) 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​(java.lang.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.
      DerivedColumnList1 fields​(java.lang.String fieldName1)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList fields​(java.lang.String... fieldNames)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList2 fields​(java.lang.String fieldName1, java.lang.String fieldName2)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList3 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList4 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList5 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList6 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList7 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList8 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList9 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList10 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList11 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10, java.lang.String fieldName11)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList12 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10, java.lang.String fieldName11, java.lang.String fieldName12)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList13 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10, java.lang.String fieldName11, java.lang.String fieldName12, java.lang.String fieldName13)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList14 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10, java.lang.String fieldName11, java.lang.String fieldName12, java.lang.String fieldName13, java.lang.String fieldName14)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList15 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10, java.lang.String fieldName11, java.lang.String fieldName12, java.lang.String fieldName13, java.lang.String fieldName14, java.lang.String fieldName15)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList16 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10, java.lang.String fieldName11, java.lang.String fieldName12, java.lang.String fieldName13, java.lang.String fieldName14, java.lang.String fieldName15, java.lang.String fieldName16)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList17 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10, java.lang.String fieldName11, java.lang.String fieldName12, java.lang.String fieldName13, java.lang.String fieldName14, java.lang.String fieldName15, java.lang.String fieldName16, java.lang.String fieldName17)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList18 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10, java.lang.String fieldName11, java.lang.String fieldName12, java.lang.String fieldName13, java.lang.String fieldName14, java.lang.String fieldName15, java.lang.String fieldName16, java.lang.String fieldName17, java.lang.String fieldName18)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList19 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10, java.lang.String fieldName11, java.lang.String fieldName12, java.lang.String fieldName13, java.lang.String fieldName14, java.lang.String fieldName15, java.lang.String fieldName16, java.lang.String fieldName17, java.lang.String fieldName18, java.lang.String fieldName19)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList20 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10, java.lang.String fieldName11, java.lang.String fieldName12, java.lang.String fieldName13, java.lang.String fieldName14, java.lang.String fieldName15, java.lang.String fieldName16, java.lang.String fieldName17, java.lang.String fieldName18, java.lang.String fieldName19, java.lang.String fieldName20)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList21 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10, java.lang.String fieldName11, java.lang.String fieldName12, java.lang.String fieldName13, java.lang.String fieldName14, java.lang.String fieldName15, java.lang.String fieldName16, java.lang.String fieldName17, java.lang.String fieldName18, java.lang.String fieldName19, java.lang.String fieldName20, java.lang.String fieldName21)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList22 fields​(java.lang.String fieldName1, java.lang.String fieldName2, java.lang.String fieldName3, java.lang.String fieldName4, java.lang.String fieldName5, java.lang.String fieldName6, java.lang.String fieldName7, java.lang.String fieldName8, java.lang.String fieldName9, java.lang.String fieldName10, java.lang.String fieldName11, java.lang.String fieldName12, java.lang.String fieldName13, java.lang.String fieldName14, java.lang.String fieldName15, java.lang.String fieldName16, java.lang.String fieldName17, java.lang.String fieldName18, java.lang.String fieldName19, java.lang.String fieldName20, java.lang.String fieldName21, java.lang.String fieldName22)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList fields​(java.util.function.BiFunction<? super Field<?>,​? super java.lang.Integer,​? extends java.lang.String> fieldNameFunction)
      Add a list of fields to this name to make this name a DerivedColumnList.
      DerivedColumnList fields​(java.util.function.Function<? super Field<?>,​? extends java.lang.String> fieldNameFunction)
      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.
      DerivedColumnList fields​(Name... fieldNames)
      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.
      java.lang.String first()
      Get the first segment of the qualified name (usually a Catalog or Schema name).
      java.lang.String[] getName()
      The qualified name of this SQL identifier.
      java.lang.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.Quoted quoted()
      Whether this is a quoted name.
      Name quotedName()
      This name, quoted.
      Name unqualifiedName()
      This name, unqualified.
      Name unquotedName()
      This name, unquoted.