vendredi 2 janvier 2015

How to remove Identity Specification for Multiple tables at once in SQL Server 2008


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