Enum Schema.TableType

  • All Implemented Interfaces:
    java.io.Serializable, java.lang.Comparable<Schema.TableType>
    Enclosing interface:
    Schema

    public static enum Schema.TableType
    extends java.lang.Enum<Schema.TableType>
    Table type.
    • Enum Constant Detail

      • TABLE

        public static final Schema.TableType TABLE
        A regular table.

        Used by DB2, MySQL, PostgreSQL and others.

      • VIEW

        public static final Schema.TableType VIEW
        A relation whose contents are calculated by evaluating a SQL expression.

        Used by DB2, PostgreSQL and others.

      • FOREIGN_TABLE

        public static final Schema.TableType FOREIGN_TABLE
        Foreign table.

        Used by PostgreSQL.

      • MATERIALIZED_VIEW

        public static final Schema.TableType MATERIALIZED_VIEW
        Materialized view.

        Used by PostgreSQL.

      • INDEX

        public static final Schema.TableType INDEX
        Index table.

        Used by Apache Phoenix, PostgreSQL.

      • JOIN

        public static final Schema.TableType JOIN
        Join table.

        Used by Apache Phoenix.

      • SEQUENCE

        public static final Schema.TableType SEQUENCE
        Sequence table.

        Used by Apache Phoenix, Oracle, PostgreSQL and others. In Phoenix, must have a single BIGINT column called "$seq".

      • STAR

        public static final Schema.TableType STAR
        A structure, similar to a view, that is the basis for auto-generated materializations. It is either a single table or a collection of tables that are joined via many-to-one relationships from a central hub table. It is not available for queries, but is just used as an intermediate structure during query planning.
      • SYSTEM_TABLE

        public static final Schema.TableType SYSTEM_TABLE
        A table maintained by the system. Data dictionary tables, such as the "TABLES" and "COLUMNS" table in the "metamodel" schema, examples of system tables.

        Specified by the JDBC standard and used by DB2, MySQL, Oracle, PostgreSQL and others.

      • SYSTEM_VIEW

        public static final Schema.TableType SYSTEM_VIEW
        System view.

        Used by PostgreSQL, MySQL.

      • SYSTEM_INDEX

        public static final Schema.TableType SYSTEM_INDEX
        System index.

        Used by PostgreSQL.

      • SYSTEM_TOAST_INDEX

        public static final Schema.TableType SYSTEM_TOAST_INDEX
        System TOAST index.

        Used by PostgreSQL.

      • SYSTEM_TOAST_TABLE

        public static final Schema.TableType SYSTEM_TOAST_TABLE
        System TOAST table.

        Used by PostgreSQL.

      • TEMPORARY_INDEX

        public static final Schema.TableType TEMPORARY_INDEX
        Temporary index.

        Used by PostgreSQL.

      • TEMPORARY_SEQUENCE

        public static final Schema.TableType TEMPORARY_SEQUENCE
        Temporary sequence.

        Used by PostgreSQL.

      • TEMPORARY_TABLE

        public static final Schema.TableType TEMPORARY_TABLE
        Temporary table.

        Used by PostgreSQL.

      • TEMPORARY_VIEW

        public static final Schema.TableType TEMPORARY_VIEW
        Temporary view.

        Used by PostgreSQL.

      • LOCAL_TEMPORARY

        public static final Schema.TableType LOCAL_TEMPORARY
        A table that is only visible to one connection.

        Specified by the JDBC standard and used by PostgreSQL, MySQL.

      • SYNONYM

        public static final Schema.TableType SYNONYM
        A synonym.

        Used by DB2, Oracle.

      • ALIAS

        public static final Schema.TableType ALIAS
        An alias.

        Specified by the JDBC standard.

      • GLOBAL_TEMPORARY

        public static final Schema.TableType GLOBAL_TEMPORARY
        A global temporary table.

        Specified by the JDBC standard.

      • ACCEL_ONLY_TABLE

        public static final Schema.TableType ACCEL_ONLY_TABLE
        An accel-only table.

        Used by DB2.

      • AUXILIARY_TABLE

        public static final Schema.TableType AUXILIARY_TABLE
        An auxiliary table.

        Used by DB2.

      • GLOBAL_TEMPORARY_TABLE

        public static final Schema.TableType GLOBAL_TEMPORARY_TABLE
        A global temporary table.

        Used by DB2.

      • HIERARCHY_TABLE

        public static final Schema.TableType HIERARCHY_TABLE
        A hierarchy table.

        Used by DB2.

      • INOPERATIVE_VIEW

        public static final Schema.TableType INOPERATIVE_VIEW
        An inoperative view.

        Used by DB2.

      • MATERIALIZED_QUERY_TABLE

        public static final Schema.TableType MATERIALIZED_QUERY_TABLE
        A materialized query table.

        Used by DB2.

      • NICKNAME

        public static final Schema.TableType NICKNAME
        A nickname.

        Used by DB2.

      • TYPED_TABLE

        public static final Schema.TableType TYPED_TABLE
        A typed table.

        Used by DB2.

      • TYPED_VIEW

        public static final Schema.TableType TYPED_VIEW
        A typed view.

        Used by DB2.

      • TEMPORAL_TABLE

        public static final Schema.TableType TEMPORAL_TABLE
        A temporal table.

        Used by MS SQL, Oracle and others

      • OTHER

        public static final Schema.TableType OTHER
        Table type not known to Calcite.

        If you get one of these, please fix the problem by adding an enum value.

    • Field Detail

      • jdbcName

        public final java.lang.String jdbcName
        The name used in JDBC. For example "SYSTEM TABLE" rather than "SYSTEM_TABLE".
    • Constructor Detail

      • TableType

        private TableType()
    • Method Detail

      • values

        public static Schema.TableType[] values()
        Returns an array containing the constants of this enum type, in the order they are declared. This method may be used to iterate over the constants as follows:
        for (Schema.TableType c : Schema.TableType.values())
            System.out.println(c);
        
        Returns:
        an array containing the constants of this enum type, in the order they are declared
      • valueOf

        public static Schema.TableType valueOf​(java.lang.String name)
        Returns the enum constant of this type with the specified name. The string must match exactly an identifier used to declare an enum constant in this type. (Extraneous whitespace characters are not permitted.)
        Parameters:
        name - the name of the enum constant to be returned.
        Returns:
        the enum constant with the specified name
        Throws:
        java.lang.IllegalArgumentException - if this enum type has no constant with the specified name
        java.lang.NullPointerException - if the argument is null