How to add auto increment column in existing table in SQL?

Question

Can anyone tell me how to add an auto-increment column in an existing table in SQL?

Answer 1

Here is the syntax to add auto-increment column in the existing table in SQL:

ALTER TABLE Table_Name

AUTO_INCREMENT = starting value;

You can specify the starting value as you want. If you do not specify the starting value will be ‘1’ and will increment by ‘1’ after every record.

I advise enrolling this course on SQL training by Intellipaat to learn SQL.