On this page

    INFORMATION_SCHEMA.“TABLES”

    The INFORMATION_SCHEMA.“TABLES” view contains metadata for the tables and views in a project.

    note:

    The name of the view must be encapsulated in quotes (“TABLES”) so that it is parsed as the view name instead of the reserved keyword table.

    Syntax
    SELECT * 
    FROM INFORMATION_SCHEMA."TABLES"
    

    Example Output

    TABLE_CATALOGTABLE_SCHEMATABLE_NAMETABLE_TYPE
    DREMIOINFORMATION_SCHEMACATALOGSSYSTEM_TABLE
    DREMIOINFORMATION_SCHEMACOLUMNSSYSTEM_TABLE
    DREMIOINFORMATION_SCHEMASCHEMATASYSTEM_TABLE
    DREMIOINFORMATION_SCHEMATABLESSYSTEM_TABLE
    DREMIOINFORMATION_SCHEMAVIEWSSYSTEM_TABLE
    DREMIOsysbootSYSTEM_TABLE
    DREMIOWeatherSFWeatherElevationVIEW
    DREMIOSamples.samples.dremio.comSF weather 2018-2019.csvTABLE
    DREMIOSamples.samples.dremio.comSF_incidents2016.jsonTABLE
    DREMIOsys.cachedatasetsSYSTEM_TABLE

    Fields

    FieldData TypeDescription
    TABLE_CATALOGvarcharName of the catalog, which is always DREMIO.
    TABLE_SCHEMAvarcharThe path (source, space, folders) to the table or view.
    TABLE_NAMEvarcharThe name of the table or view.
    TABLE_TYPEvarcharThe type of the object.
    Enum: SYSTEM_TABLE, TABLE, VIEW