CODEWITHSUNDEEP
mysqlsql
SUBASRI K
SUBASRI K

Reputation: 1

Where will the auto increment value be stored in sql?

I saw multiple posts about getting the last auto increment value. But my question is Where will these autoincrement values stored in SQL?

Thanks in advance

Upvotes: 0

Views: 646

Answers (1)

Jahangir
Jahangir

Reputation: 161

Actually auto increment value is managed by DBMS. You can just get IDENT_CURRENT and IDENT_INCR value by request to DBMS.

Like. select IDENT_CURRENT('tblname') => get the current auto incremented record value

select IDENT_INCR('tblname') => get increment rate.

Upvotes: 1

Related Questions