Usage of IDENT_INCR and IDENT_SEED function of Identity column in sql server
Here we are see how to get
the Increment & Seed Settings of Indentity in the table.
IDENTITY(SEED,INCREMENT)==
IDENTITY(10,5)
Query Snippet:
-- Create
table with identity column
CREATE
TABLE MyOrders2
(
OrderID
int IDENTITY(10,5),
ProductName varchar(20)
);
select
IDENT_INCR('MyOrders2')
-- 5
select
IDENT_SEED
('MyOrders2')
-- 10
drop table MyOrders2
-- Create
table with identity column
CREATE
TABLE MyOrders2
(
OrderID
int IDENTITY(100,50),
ProductName varchar(20)
);
select
IDENT_INCR('MyOrders2')
-- 50
select
IDENT_SEED
('MyOrders2')
– 100
Try After Reseting the Indentity by the below command:
dbcc CHECKIDENT('MyOrders2',RESEED,10)
It still shows the original setup in the table not the reset value by “CHECKIDENT” command.
select
IDENT_INCR('MyOrders2')
-- 50
select
IDENT_SEED
('MyOrders2')
– 100
Join the conversation! Your thoughts help the community grow.