85

Enable Primary Key

ALTER INDEX statement is used to enable a primary key in SQL Server database.

Syntax:

Example:

Enable the primary key “customer_id” on the table “customers”.

Output:

Now primary key “customer_id” is enabled in table “customers”.