SQL SERVER self-add Column modification view Close action

CREATE TABLE Tb_name

(

ID INT not NULL IDENTITY PRIMARY KEY,

Title NVARCHAR (+) NULL

)

View the columns in the Tb_name table that are self-growing

SELECT TOP (1) identitycol from Tb_name

View the current value of the self-growing column in the Tb_name table

DBCC checkident (Tb_name)

Modify the current value of the self-growing column in the Tb_name table

DBCC checkident (Tb_name, Reseed, 89)

Close the self-growing column in the Tb_name table

SET Identity_insert Tb_name on
INSERT into Tb_name (ID, title) VALUES (22, ' new Value added ')

Open the self-growing column in the Tb_name table

SET identity_insrt tb_name OFF;

SQL SERVER self-add Column modification view Close action