CODEWITHSUNDEEP
mysql
Dominating
Dominating

Reputation: 2930

Add auto_increment to primary key in SQL

I have table named A with column B defined int not null Primary Key and there are 4-5 foreign keys that point to this column already. With what syntax of Alter to make this primary key column be AUTO_INCREMENT ?

Upvotes: 1

Views: 2133

Answers (3)

NT88
NT88

Reputation: 947

ALTER TABLE A AUTO_INCREMENT=1

Upvotes: 1

Sai Kalyan Kumar Akshinthala
Sai Kalyan Kumar Akshinthala

Reputation: 11844

If its a primary column go to the table defination, there u can set the auto increment value in the column properties. go to the Column Properties ----> click on identity Specification -----> give the identity increment value and the identity seed value. then for every new row the value will be auto incremented.

Upvotes: 1

Davide Piras
Davide Piras

Reputation: 44605

Hi does something like this work?

alter table A B int NOT NULL AUTO_INCREMENT

I believe you should use something similar, if you use SQLYog to do it with the user interface then you see in the history tab the corresponding alter command generated.

Upvotes: 1

Related Questions