Skip to main content

Information_Schema Tables

Information Schema

TableDescription
tablesANSI SQL standard metadata view for tables.
schemataANSI SQL standard metadata view for databases.
viewsANSI SQL standard metadata view for views.
keywordsANSI SQL standard metadata view for keywords.
columnsANSI SQL standard metadata view for columns.
SHOW VIEWS FROM INFORMATION_SCHEMA;
╭─────────────────────────────╮
│ Views_in_information_schema │
│ String │
├─────────────────────────────┤
columns
│ key_column_usage │
│ keywords │
│ schemata │
statistics
tables
│ views │
╰─────────────────────────────╯

Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today