DBA_TAB_COLUMNS
DBA_TAB_COLUMNS stores the columns of tables and views. Each column of a table in the database has a row in DBA_TAB_COLUMNS. Only users with system administrator permissions can access this view.
Name |
Type |
Description |
---|---|---|
owner |
character varying(64) |
Owner of a table/view |
table_name |
character varying(64) |
Table/View name |
column_name |
character varying(64) |
Column name |
data_type |
character varying(128) |
Data type of the column |
column_id |
integer |
Sequence number of the column when a table/view is created |
data_length |
integer |
Length of the column, in bytes |
comments |
text |
Comments |
avg_col_len |
numeric |
Average length of a column, in bytes |
nullable |
bpchar |
Whether the column can be empty. For the primary key constraint and non-null constraint, the value is n. |
data_precision |
integer |
Precision of the data type. This parameter is valid for the numeric data type and NULL for other data types. |
data_scale |
integer |
Number of decimal places. This parameter is valid for the numeric data type and 0 for other data types. |
char_length |
numeric |
Length of a column, in characters. This parameter is valid only for the varchar, nvarchar2, bpchar, and char types. |
schema |
character varying(64) |
Namespace that contains the table or view. |
kind |
text |
Type of the current record. If the column belongs to a table, the value of this column is table. If the column belongs to a view, the value of this column is view. |
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