schema_auto_increment_columns Sys Schema View
MariaDB starting with 10.6
The Sys Schema was introduced in MariaDB 10.6
Description
Information about AUTO_INCREMENT columns, sorted by descending usage ratio and maximum column value. Does not include columns in the mysql, sys, information_schema and performance_schema schemas.
Contains the following columns:
Column
Description
table_schema
Schema name containing the table with the auto_increment attribute.
table_name
Table containing the auto_increment attribute.
column_name
Name of the column containing the auto_increment attribute.
column_type
Data type of the auto_increment column, plus additional information for example tinyint(3) unsigned.
is_signed
1 if the column is signed,0 if not.
is_unsigned
1 if the column is unsigned,0 if it is.
max_value
Maximum possible value for the column, for example 255 for an unsigned tinyint.
auto_increment
Current auto_increment value for the column.
auto_increment_ratio
Ratio of used to maximum value for the auto_increment column.
Example
This page is licensed: CC BY-SA / Gnu FDL
Last updated
Was this helpful?