MY_TAB_COLUMNS
MY_TAB_COLUMNS displays information about table columns accessible to the current user. This view exists in both PG_CATALOG and SYS schema.
Name |
Type |
Description |
---|---|---|
owner |
character varying(64) |
Table owner. |
table_name |
character varying(64) |
Table name. |
column_name |
character varying(64) |
Column name. |
data_type |
character varying(128) |
Data type of the column. |
data_length |
integer |
Length of the column, in bytes. |
data_precision |
integer |
Precision of a data type. This column is valid for the numeric data type and NULL for other data types. |
data_scale |
integer |
Number of decimal places. This column is valid for the numeric data type and 0 for other data types. |
nullable |
bpchar |
Specifies whether a column can be empty (n for a primary key constraint or NOT NULL constraint). |
column_id |
integer |
Sequence number of the column when the table is created. |
avg_col_len |
numeric |
Average length of a column, in bytes. |
char_length |
numeric |
Length of a column, in characters. This parameter is valid only for the varchar, nvarchar2, bpchar, and char types. |
comments |
text |
Comments. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot