How can i get the seed value of an identity column in MySql
- by mmcdonald
To get the seed and step values of an identity column in sql server i can use this syntax
SELECT ColumnName = name, Seed = seed_value, Step = increment_value
FROM sys.identity_columns
So far in MySql i have found that if i use this syntax
SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE auto_increment IS NOT NULL
I can at least find out which columns are an identity...
The question being how can i get the SEED and STEP values of the identity column from the MySQL Schema.
