MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0
This view indicates which tables have
AUTO_INCREMENT columns and provides
information about those columns, such as the current and
maximum column values and the usage ratio (ratio of used to
possible values). By default, rows are sorted by descending
usage ratio and maximum column value.
Tables in these schemas are excluded from view output:
mysql, sys,
INFORMATION_SCHEMA,
performance_schema.
The
schema_auto_increment_columns
view has these columns:
table_schema
The schema that contains the table.
table_name
The table that contains the
AUTO_INCREMENT column.
column_name
The name of the AUTO_INCREMENT column.
data_type
The data type of the column.
column_type
The column type of the column, which is the data type plus
possibly other information. For example, for a column with
a bigint(20) unsigned column type, the
data type is just bigint.
is_signed
Whether the column type is signed.
is_unsigned
Whether the column type is unsigned.
max_value
The maximum permitted value for the column.
auto_increment
The current AUTO_INCREMENT value for
the column.
auto_increment_ratio
The ratio of used to permitted values for the column. This indicates how much of the sequence of values is “used up.”