The tables Information Schema View
The tables Information Schema view contains one
row for each table to which you have access. It contains the following
columns.
| Column | Data Type | Explanation |
|---|---|---|
| table_schema | VARCHAR(32) | Name of owner of table |
| table_name | VARCHAR(128) | Name of table or view |
| table_type | VARCHAR(128) | BASE TABLE for table or VIEW for view |
| remarks | VARCHAR(255) | Reserved for future use |
The visible rows in the tables view depend on your privileges. For example, if you have one or more privileges on a table (such as Insert, Delete, Select, References, Alter, Index, or Update on one or more columns), or if privileges are granted to PUBLIC, you see the row that describes that table.