Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to drop the index without droping PK?

Status
Not open for further replies.
Mar 29, 2004
120
US
Hi,

I was wondering how can I drop or disable the index on the PK field without disabling the promary key?
In case I need to Bulk Insert or something.

Thanks
 
No. What makes the primary key is the index. You can't do anything with the index while the Primary key is still defined.

Denny

--Anything is possible. All it takes is a little research. (Me)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top