I am having total 109 table in Database and now i am migrating to amazon server with identity insert and now i want to remove auto increment column specification for all tables. How set auto increment column i.e Identity specification to no in SQL server 2008 for all tables.
For Example
I am having
CREATE TABLE dbo.tbl_acc
(
a1 NUMERIC (18) IDENTITY NOT NULL,
a2 NUMERIC (18) NULL,
a3 VARCHAR (4000) NULL,
a4 VARCHAR (3999) NULL,
CONSTRAINT PK_tbl_acc PRIMARY KEY (a1)
)
GO
And now i would like to remove IDENTITY. Not only for this remaining all tables.
Aucun commentaire:
Enregistrer un commentaire