Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hungleon88
Starting Member
16 Posts |
 Posted - 2008-07-31 : 07:00:35
|
| How to drop the clustered index in the column have constraint primary key????? |
|
|
pootle_flump
1064 Posts |
Posted - 2008-07-31 : 07:02:23
|
| Drop the primary key and vwalah - the clustered index goes too. |
 |
|
|
hungleon88
Starting Member
16 Posts |
Posted - 2008-07-31 : 07:21:12
|
| i can Alter table table_name drop constraint PK (the constraint exist when i create table and have "constraint primary key PK(column_name)")but when i create table with this: create table table_name(column_name primary key)it doesn't have constrainthow can i drop the primary key???? |
|
|
|
VGuyz
Posting Yak Master
121 Posts |
|
|
hungleon88
Starting Member
16 Posts |
Posted - 2008-07-31 : 07:33:40
|
| ok thanks all !!!!!! |
|
|
|
|
|
|
How to drop the clustered index ??