Can We Add Primary Key Existing Table With Data?
Can We Add Primary Key Existing Table With Data? Because a table can have only one primary key, you cannot add a primary key to a table that already has a primary key defined. To change the primary key of a table, delete the existing key using a DROP clause in an ALTER TABLE statement