This view contains the following information on each user-defined or publicly created table:
| Column Heading | Definition |
|---|---|
| table_catalog | Database containing the table |
| table_schema | Schema (owner) of the table; the owner can be either the current schema (user) viewing the INFORMATION_SCHEMA or the PUBLIC schema |
| table_name | Name of the table |
| table_type | Type of table — the possible values are:
|