columns

Overview

View all column information.

Database

information_schema

Table Information

Column Name	Type	Description
TABLE_CATALOG	varchar(512)	Catalog name
TABLE_SCHEMA	varchar(64)	Database name
TABLE_NAME	varchar(64)	Table name
COLUMN_NAME	varchar(64)	Column name
ORDINAL_POSITION	bigint	The position of the column in the table
COLUMN_DEFAULT	varchar(1024)	Default value of the column
IS_NULLABLE	varchar(3)	Whether NULL is allowed
DATA_TYPE	varchar(64)	Data type
CHARACTER_MAXIMUM_LENGTH	bigint	Maximum number of characters allowed for character types
CHARACTER_OCTET_LENGTH	bigint	Maximum number of bytes allowed for character types
NUMERIC_PRECISION	bigint	Precision for numeric types
NUMERIC_SCALE	bigint	Scale for numeric types
DATETIME_PRECISION	bigint	Precision for datetime types
CHARACTER_SET_NAME	varchar(32)	Character set name for character types, always NULL
COLLATION_NAME	varchar(32)	Collation algorithm name for character types, always NULL
COLUMN_TYPE	varchar(32)	Column type
COLUMN_KEY	varchar(3)	If 'UNI', it indicates that the column is a Unique Key column
EXTRA	varchar(27)	Additional information about the column, including whether it is an auto-increment column, a generated column, etc.
PRIVILEGES	varchar(80)	Always empty
COLUMN_COMMENT	varchar(255)	Comment information for the column
COLUMN_SIZE	bigint	Width of the column
DECIMAL_DIGITS	bigint	Number of decimal places for numeric types
GENERATION_EXPRESSION	varchar(64)	Always NULL
SRS_ID	bigint	Always NULL