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

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

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