Database > Schema INFORMATION_SCHEMA > Table COLUMNS

Table COLUMNS

Summary

Columns

Name Type Comment
TABLE_CATALOG VARCHAR(2147483647,0)
TABLE_SCHEMA VARCHAR(2147483647,0)
TABLE_NAME VARCHAR(2147483647,0)
COLUMN_NAME VARCHAR(2147483647,0)
ORDINAL_POSITION INTEGER(10,0)
COLUMN_DEFAULT VARCHAR(2147483647,0)
IS_NULLABLE VARCHAR(2147483647,0)
DATA_TYPE INTEGER(10,0)
CHARACTER_MAXIMUM_LENGTH INTEGER(10,0)
CHARACTER_OCTET_LENGTH INTEGER(10,0)
NUMERIC_PRECISION INTEGER(10,0)
NUMERIC_PRECISION_RADIX INTEGER(10,0)
NUMERIC_SCALE INTEGER(10,0)
CHARACTER_SET_NAME VARCHAR(2147483647,0)
COLLATION_NAME VARCHAR(2147483647,0)
TYPE_NAME VARCHAR(2147483647,0)
NULLABLE INTEGER(10,0)
IS_COMPUTED BOOLEAN(1,0)
SELECTIVITY INTEGER(10,0)
CHECK_CONSTRAINT VARCHAR(2147483647,0)
SEQUENCE_NAME VARCHAR(2147483647,0)
REMARKS VARCHAR(2147483647,0)

Relations

Table Type

Constraints, Indexes and Triggers

Table Type

Columns

TABLE_CATALOG

TABLE_SCHEMA

TABLE_NAME

COLUMN_NAME

ORDINAL_POSITION

COLUMN_DEFAULT

IS_NULLABLE

DATA_TYPE

CHARACTER_MAXIMUM_LENGTH

CHARACTER_OCTET_LENGTH

NUMERIC_PRECISION

NUMERIC_PRECISION_RADIX

NUMERIC_SCALE

CHARACTER_SET_NAME

COLLATION_NAME

TYPE_NAME

NULLABLE

IS_COMPUTED

SELECTIVITY

CHECK_CONSTRAINT

SEQUENCE_NAME

REMARKS