-- Create Table

CREATE TABLE MyTable (MyId INT IDENTITY (1,1),

MyCity NVARCHAR(50),

CONSTRAINT PK_MyId PRIMARY KEY CLUSTERED (MyId))

-- Populate Dummy data

INSERT INTO MyTable VALUES ('Boston')

INSERT INTO MyTable VALUES ('New Delhi')

-- Disable Clustered Index

ALTER INDEX PK_MyId ON MyTable DISABLE

GO

-- Drop the associated constraints

ALTER TABLE MyTable DROP CONSTRAINT PK_MyIdGO

-- Check

SELECT * FROM MyTable

-- Cleanup!

DROP TABLE MyTable