Post
Ask Question

Create and Drop Primary Key Without Using Wizard in SQL Server

Suppose there is an Employee
 
Create Primary Key
  1. ALTER TABLE [dbo].[Employee] ADD  CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED   
  2. (  
  3.     [id] ASC  
  4. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] 
 Drop Primary Key
  1. ALTER TABLE [dbo].[Employee] DROP CONSTRAINT [PK_Employee]