How change the identity increment of column?

Following statement can reset Seed

DBCC Checkident (TB, reseed, 5 )

But can't reset increment.

How change the identity increment of column?

I can't find the simple method, Now I use following SQL script to change it.

Use Tempdb
Go
If   Exists ( Select   *   From SYS. Tables Where Name = ' TB ' )
Drop   Table TB
Go
Create   Table TB (ID Int   Identity ( 1 , 1 ) Primary   Key , Name Varchar ( 20 ))
Go
Insert   Into TB Select   ' A '
Go   5

Select * FromTB

Create   Table Tb_tmp (ID Int   Identity ( 1000 , 5 ) Primary   Key , Name Varchar ( 20 ))
Go
Set   Identity_insert Tb_tmp On
Insert Tb_tmp (ID, name) Select ID, name From TB With (Xlock, tablock)
Set   Identity_insert Tb_tmp Off
Drop   Table TB
Go
Exec Sp_rename n ' Tb_tmp ' , N ' TB '
Go
Insert   Into TB (name) Select   ' B '
Go   5
Select   *   From TB

 

Please tell me if you find bugs

Thanks for reading,

Nzperfect