Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

AUTO NUmber column in SQL server

2 Posts 2 Posters 0 Views 1 Watching

J Offline
J Offline
jonhbt

wrote on last edited by

#1

Hi I have created tables with their primary keys as integers. How can I write a statement to Alter the primary key and set the identity (autonumber) on it in SQL Server? Thanks
B 1 Reply Last reply

0
J jonhbt

Hi I have created tables with their primary keys as integers. How can I write a statement to Alter the primary key and set the identity (autonumber) on it in SQL Server? Thanks
B Offline
B Offline
Baran M

wrote on last edited by

#2

ALTER TABLE MyCustomers ALTER COLUMN CustId IDENTITY (100,1);

Education is not a way to escape poverty — it is a way of fighting it.
1 Reply Last reply

0

Log in to reply