SQL Server & SQLCE Identity값(SEED값) 알아오는 쿼리

MSSQL Server

dbcc CHECKIDENT('테이블명', NORESEED)

 

=> 참고로 설정은 dbcc CHECKIDENT('테이블명', RESEED, SEED값)

 

SQLCE

 

SELECT  TABLE_NAME, COLUMN_NAME, AUTOINC_NEXT, AUTOINC_SEED
FROM     INFORMATION_SCHEMA.COLUMNS
WHERE  (AUTOINC_NEXT IS NOT NULL)