Column meta data
Foreign key meta data
Foreign key meta data
column name
column name on the foreign table
foreign table name
Index meta data.
Index meta data.
name index name; null when TYPE is tableIndexStatistic
target column names (collection of COLUMN_NAME without null values: column name; null when TYPE is tableIndexStatistic)
unique index (opposite of NON_UNIQUE: Can index values be non-unique. false when TYPE is tableIndexStatistic)
index catalog (may be null); null when TYPE is tableIndexStatistic
index type: tableIndexStatistic, tableIndexClustered, tableIndexHashed, tableIndexOther
column sequence number within index; zero when TYPE is tableIndexStatistic
column sort sequence, "A" => ascending, "D" => descending, may be null if sort sequence is not supported; null when TYPE is tableIndexStatistic
When TYPE is tableIndexStatistic, then this is the number of rows in the table; otherwise, it is the number of unique values in the index.
When TYPE is tableIndexStatisic then this is the number of pages used for the table, otherwise it is the number of pages used for the current index.
Filter condition, if any. (may be null)
Index type.
Table meta data
Table meta data
name
schema
description
columns
foreign keys
indices
Column meta data
name
type code(int)
type name
size
not null
primary key
auto increment
comment
default value