Information Schema
Dremio stores metadata for the objects in your project in the Information Schema, which is a set of system-generated read-only views (cannot be modified or dropped). The Dremio Information Schema is based on the ANSI Information Schema.
The following views can be queried to return metadata for the respective catalog objects.
| View | Description |
|---|---|
| INFORMATION_SCHEMA.CATALOGS | The information about the catalog that contains the metadata of a project. |
| INFORMATION_SCHEMA.COLUMNS | The metadata for all the columns within the tables and views in a project. |
| INFORMATION_SCHEMA.SCHEMATA | The metadata for the sources in a project. |
| INFORMATION_SCHEMA."TABLES" | The metadata for the tables and views in a project. |
| INFORMATION_SCHEMA.VIEWS | The metadata for views in a project. |