COLUMNS

The COLUMNS view contains the name and system identifier for each column. The table below lists the columns that are associated with the COLUMNS view:
Name
Type
Description
CATALOG_NAME
VARCHAR(256)
Specifies the catalog name.
SCHEMA_NAME
VARCHAR(256)
Specifies the schema name.
OBJECT_NAME
VARCHAR(256)
Specifies the object name.
COLUMN_NAME
VARCHAR(256)
Specifies the column name.
Last updated: March 6, 2018