The view tables contains all tables
and views defined in the current database. Only those tables and
views are shown that the current user has access to (by way of
being the owner or having some privilege).

Table 30-34. tables
Columns

Name

Data Type

Description

table_catalog

sql_identifier

Name of the database that contains the table (always
the current database)

table_schema

sql_identifier

Name of the schema that contains the table

table_name

sql_identifier

Name of the table

table_type

character_data

Type of the table: BASE
TABLE for a persistent base table (the normal table
type), VIEW for a view, or
LOCAL TEMPORARY for a temporary
table