Tables View

Lists the tables defined in the catalog.

This view is part of the ANSI SQL-2 standard Information Schema.

 

Column

Data Type

N

Description

RECORD_NUMBER

integer

n

unique identifier for this record of metadata

TABLE_CATALOG

identifier

n

table catalog

TABLE_SCHEMA

identifier

n

table schema

TABLE_NAME

identifier

n

table name

TABLE_TYPE

enumeration

n

table type: Base Table or View