How to change Column Properties In SQL?

I have many tables; each has a primary key which is an Identity column wit开发者_开发问答h a seed of 1.

I have another program which converts data from a previous database (dBase) to sql.

This programs needs Indentity = No.

How can I change Identity and Identity Seed from my code?

It sounds like you want to insert values into the IDENTITY column

You can do that using

SET IDENTITY_INSERT TableName ON

INSERT INTO MyTable (IdentityColumn, Column1, Column2) Values (1, 2, 3)

SET IDENTITY_INSERT TableName OFF

Note: you must specify all the column names

To reseed identity (to lets say start at 77) use the following command

dbcc checkident(TableName, RESEED, 77)

There's no need to break the table for the sake of a data import, just do this:

set identity_insert MyTable on

insert into MyTable ... blah blah blah

set identity_insert MyTable off