Anyway, add the main key of the autodial into the existing database table

Question

I have inherited a database application from someone else, and there are several tables that do not have any primary keys. I want to add a new column to an existing table and have its autonomy (starting from 1). How can i do this?

Answer 1

SQL Server Syntax:

ALTER TABLE SomeTable ADD
    ID int NOT NULL IDENTITY(1, 1),
    CONSTRAINT PK_SomeTable PRIMARY KEY [NON]CLUSTERED (ID)