Get a specific column
get
/database/objects/columns/{owner},{table_name},{column_name}
Returns the corresponding record from DBA_TAB_COLUMNS or ALL_TAB_COLUMNS view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.
Request
Supported Media Types
- application/json
Path Parameters
-
column_name: string
Name of the column.
-
owner: string
Owner for the index.
-
table_name: string
Name of the table the column belongs to.
Response
Supported Media Types
- application/json
200 Response
Information on a specific column.
Root Schema : DatabaseObjectsColumnsItem
Type:
object
Title:
DatabaseObjectsColumnsItem
Describes the column of table, view, or cluster in the database.
Show Source
-
avg_col_len(optional):
integer(int32)
Average length of the column (in bytes).
-
char_col_decl_length(optional):
number(double)
Declaration length of the character type column.
-
char_length(optional):
integer(int32)
Displays the length of the column in characters.
-
char_used(optional):
string
Indicates that the column uses BYTE length semantics (B) or CHAR length semantics (C), or whether the data type is not any of the following (NULL): CHAR, VARCHAR2, NCHAR, NVARCHAR2.
-
character_set_name(optional):
string
Name of the character set.
-
collation(optional):
string
Collation for the column. Only applies to columns with character data types.
-
column_id(optional):
integer(int32)
Sequence number of the column as created.
-
column_name(optional):
string
Column name.
-
data_default(optional):
integer(int32)
Default value for the column.
-
data_length(optional):
integer(int32)
Length of the column (in bytes).
-
data_precision(optional):
integer(int32)
Decimal precision for NUMBER data type; binary precision for FLOAT data type; NULL for all other data types.
-
data_scale(optional):
integer(int32)
Digits to the right of the decimal point in a number.
-
data_type(optional):
string
Data type of the column.
-
data_type_mod(optional):
string
Data type modifier of the column.
-
data_type_owner(optional):
string
Owner of the data type of the column.
-
data_upgraded(optional):
string
Indicates whether the column data has been upgraded to the latest type version format (YES) or not (NO).
-
default_length(optional):
number(double)
Length of the default value for the column.
-
default_on_null(optional):
string
Indicates whether the column has DEFAULT ON NULL semantics (YES) or not (NO).
-
density(optional):
number(double)
If a histogram is available on COLUMN_NAME, then this column displays the selectivity of a value that spans fewer than 2 endpoints in the histogram. It does not represent the selectivity of values that span 2 or more endpoints. If a histogram is not available on COLUMN_NAME, then the value of this column is 1/NUM_DISTINCT.
-
evaluation_edition(optional):
string
Name of the edition in which editioned objects referenced in an expression column are resolved.
-
global_stats(optional):
string
GLOBAL_STATS will be YES if statistics are gathered or incrementally maintained, otherwise it will be NO.
-
high_value(optional):
string
High value in the column.
-
histogram(optional):
string
Indicates existence/type of histogram.
-
identity_column(optional):
string
Indicates whether this is an identity column (YES) or not (NO).
-
last_analyzed(optional):
string
Date on which this column was most recently analyzed.
-
links(optional):
array links
-
low_value(optional):
string
Low value in the column.
-
nullable(optional):
string
Indicates whether a column allows NULLs. The value is N if there is a NOT NULL constraint on the column or if the column is part of a PRIMARY KEY. The constraint should be in an ENABLE VALIDATE state.
-
num_buckets(optional):
integer(int32)
Number of buckets in the histogram for the column.
-
num_distinct(optional):
number(double)
Number of distinct values in the column.
-
num_nulls(optional):
integer(int32)
Number of NULLs in the column.
-
owner(optional):
string
Owner of the table, view, or cluster.
-
sample_size(optional):
integer(int32)
Sample size used in analyzing this column.
-
sensitive_column(optional):
string
Indicates whether this is a sensitive column (YES) or not (NO).
-
table_name(optional):
string
Name of the table, view, or cluster.
-
unusable_before(optional):
string
Name of the oldest edition in which the index may be used as part of a query plan.
-
unusable_beginning(optional):
string
Name of the edition for which the index may not be used as part of a query plan in this edition or any of its descendants.
-
user_stats(optional):
string
Indicates whether statistics were entered directly by the user (YES) or not (NO).
-
v80_fmt_image(optional):
string
Indicates whether the column data is in release 8.0 image format (YES) or not (NO).