clusterd index

Question

Post reply

clusterd index

satyawan_sanap

SSC Rookie

Points: 29
More actions
January 16, 2009 at 4:56 am

#204146

how to drop the clustered index????

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Mike John SSCertifiable Points: 7186 More actions · Answer 1

drop index tablename.indexname

But I suspect there maybe more to your question! Is this index used to support a primary key or unique constraint?

Mike John

CrazyMan SSChampion Points: 12560 More actions · Answer 2

Alter table

Alter table Table Name Drop Constraint ConstraintName

Check MSDN 🙂 for more information

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

CrazyMan (1/16/2009)
Alter table
Alter table Table Name Drop Constraint ConstraintName

True, if the clustered index is part of a primary key or unique constraint. If it's just a plain index, DROP INDEX is the command to use.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

satyawan_sanap SSC Rookie Points: 29 More actions · Answer 4

it's a primary key clustered.. so wt would be the ans???

Old McDonald SSCertifiable Points: 5768 More actions · Answer 5

Alter table query stated by crazyman is your solution

-Vikas Bindra

NitinPatel31 Hall of Fame Points: 3721 More actions · Answer 6

You can use ALTER TABLE statment...

But why do you want to drop clustered index on PK? Is yous PK generaation not in order? Or want to created clustered index on other key columns?

Regards,
Nitin

Dugi SSCoach Points: 17998 More actions · Answer 7

satyawan_sanap (1/16/2009)
it's a primary key clustered.. so wt would be the ans???

ALTER TABLE YOUR_TABLE

DROP CONSTRAINT your_constraint_name

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Dugi SSCoach Points: 17998 More actions · Answer 8

And be sure that you do not have any Foregin Key from other tables which is referenced to the PK ( Your Clustered Index)

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

rajluves SSC Veteran Points: 217 More actions · Answer 9

rajluves

SSC Veteran

Points: 217

October 7, 2013 at 11:21 pm

#1656611

drop index indexname on tablename

Sean Pearce SSCoach Points: 15999 More actions · Answer 10

rajluves (10/7/2013)
drop index indexname on tablename

Incorrect answer to a 5 year old post.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]