查看数据库中每张表自增种子值、增量值

程序员文章站 2022-06-15 19:15:20

...

查看数据库中每张表自增种子值、增量值无 SELECT TABLE_NAME,IDENT_SEED(TABLE_NAME) AS IDENTITY_SEED,IDENT_INCR(TABLE_NAME) AS IDENTITY_INCREASE FROM INFORMATION_SCHEMA.TABLES WHERE IDENT_SEED(TABLE_NAME) IS NOT NULL

查看数据库中每张表自增种子值、增量值

SELECT TABLE_NAME,IDENT_SEED(TABLE_NAME) AS IDENTITY_SEED,IDENT_INCR(TABLE_NAME) AS IDENTITY_INCREASE FROM INFORMATION_SCHEMA.TABLES WHERE IDENT_SEED(TABLE_NAME) IS NOT NULL

相关标签：查看数据库每张表自种子量值查看数据库每张表

上一篇：修改mysql5.5默认编码(图文步骤修改为utf-8编码)_MySQL

下一篇： Oracle存储过程的学习体会