Information_Schema Tables
Information Schema
Table | Description |
---|---|
tables | ANSI SQL standard metadata view for tables. |
schemata | ANSI SQL standard metadata view for databases. |
views | ANSI SQL standard metadata view for views. |
keywords | ANSI SQL standard metadata view for keywords. |
columns | ANSI 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 │
╰─────────────────────────────╯