DATABASES view
The MD_INFORMATION_SCHEMA.DATABASES view provides information about the current databases that the user created.
Schema
When you query the MD_INFORMATION_SCHEMA.DATABASES view, the query results contain one row for each database that the current user created.
The MD_INFORMATION_SCHEMA.DATABASES view has the following schema:
| Column Name | Data Type | Value |
|---|---|---|
| NAME | STRING | The name or alias of the database |
| UUID | STRING | The UUID of the database |
| CREATED_TS | TIMESTAMP | The database’s creation time |
Example usage
from MD_INFORMATION_SCHEMA.DATABASES;
| name | uuid | created_ts |
|---|---|---|
| tpch_sf1000_template | 2c80b37d-d307-44d8-aff6-33ea2294bd35 | 2024-10-21 14:26:30-04 |
| db1 | 445864c7-5758-42a2-9a5c-2f16620ebc9f | 2024-09-15 09:32:05-04 |
| foo | 4d829a9e-e0da-408c-aafa-0fc50186a588 | 2024-09-03 13:32:10-04 |
| tpch_sf1000 | fc4bf9f4-80d1-4fd9-b6fe-d6d71f40ef42 | 2024-10-21 14:26:30-04 |