Skip to main content

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 tables.

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