sql server how to assign a primary key to a table containing data

Question

sql server how to assign a primary key to a table containing data

Navigation

#1 by (0 votes)

0

I have a table that is or is called Invoices which at the time of creation was created without a PK this table already has several records and now I want to add a column with a PK because the records I need from this table I want to make it a unique record.

sql-server-2012

asked by Daniel Soto 11.01.2018 в 21:13

source

1 answer

Problem with fetch_assoc () How to send cake php form by Ajax?

score 0 · Accepted Answer

Before adding the Pk you need to add the field "id" that you want to use in your case you can not call it invoiceId and with the instruction IDENTITY we will make the field be auto incremental, as follows:

 alter table Facturas add IdFacturas int NOT NULL IDENTITY(1, 1);

Then you have to add the PK

 alter table Facturas add primary key (IdFacturas);

Search in google the following alter table primary key sql server

and voilà add-primary-key-to-existing-table

PS: you should put your table as additional information so that others understand you, in this case it is easier because what you need is something known.