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

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

编程技巧