probably a simple one for you guys.
But say I have 100 tables in my database.
Each table has a int column called "ID". ID has the properties:
Identity = No
I want them to be:
Identity = Yes
Identity Seed = 1
Identity Increment = 1
Now I don't want to go changed every single one in the database manually.. (ie. in EM : right click on table name -> design -> change the properties and save) I want to be able to fire a script off or something which will find all the tables in the database with the column "ID" and change their properties.