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