Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.48 USER_TABLES

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.48 USER_TABLES

The USER_TABLES view displays information about all tables owned by the current user.

Name

Type

Description

owner

TEXT

User name of the table’s owner.

schemaname

TEXT

Name of the schema in which the table belongs.

table_name

TEXT

Name of the table.

table_space

TEXT

Name of the tablespace in which the table resides if other than the default tablespace.

status

VARCHAR2(5)

Included for compatibility only; always set to VALID..

Previous PageTable Of ContentsNext Page