Postgres Plus Advanced Server Oracle Compatibility Developer's Guide : 10.47 USER_TAB_COLUMNS

Previous PageTable Of ContentsNext Page

Postgres Plus Advanced Server Oracle Compatibility Developer's Guide

 

10.47 USER_TAB_COLUMNS

The USER_TAB_COLUMNS view displays information about all columns in 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.

column_name

TEXT

Name of the column.

data_type

VARCHAR2

Data type of the column.

data_length

INTEGER

Length of text columns.

data_precision

INTEGER

Precision (number of digits) for NUMBER columns.

data_scale

INTEGER

Scale of NUMBER columns.

column_id

INTEGER

Relative position of the column within the table.

nullable

BPCHAR

Whether or not the column is nullable – possible values are: Y – column is nullable; N – column does not allow null.

data_default

VARCHAR2

Default value assigned to the column.

Previous PageTable Of ContentsNext Page