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 │
╰─────────────────────────────╯

Try Databend Cloud for FREE

Multimodal, object-storage-native warehouse for BI, vectors, search, and geo.

Snowflake-compatible SQL with automatic scaling.

Sign up and get $200 in credits.

Try it today