Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Issue

This is a discussion on Issue within the SQL Server forums, part of the Databases category; If we create a primary key then automatically it creates an unique clusterd index, but for any table there is only one clusterd index is allowed, If i want to ...

Geeks Talk > Databases > SQL Server Issue

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   05-19-2008

nageshkota Junior Member   Join Date: Apr 2008 Posts: 19 Thanks: 1 Thanked 1 Time in 1 Post

Issue If we create a primary key then automatically it creates an unique clusterd index, but for any table there is only one clusterd index is allowed, If i want to create an uniue clusterd index on other column can i do it? If how?

The Following User Says Thank You to nageshkota For This Useful Post:

R.Santhosh kumar

Sponsored Links

#2 (permalink)   05-20-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,330 Thanks: 7 Thanked 117 Times in 106 Posts

Re: Issue please find a related discussion here.

#3 (permalink)   3 Weeks Ago

mobinsk Junior Member   Join Date: Jul 2008 Location: Hyderabad Posts: 6 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Issue Hi, As you mentioned above it is not possible to create more than one clustered index or unique clustered index. So, For creating new one drop the existing one.

#4 (permalink)   1 Week Ago

nageshkota Junior Member   Join Date: Apr 2008 Posts: 19 Thanks: 1 Thanked 1 Time in 1 Post

Re: Issue Hi mobin, It is possible to create more than one clustred index on a table. so You answer is wrong...

Geeks Talk > Databases > SQL Server

« Very important | How to get 6th heghest salary? »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Testing issue	sakshi_2801	Testing Issues	3	01-21-2008 01:33 AM
Date range issue	mallieka	Java	1	10-24-2007 01:07 AM
MATLAB Issue	kamanianil	PeopleSoft	1	10-05-2007 09:52 AM
security issue in UNIX	gummadi	Unix/Linux	1	09-25-2007 07:19 AM
ADF table issue..	psuresh1982	Oracle	1	07-19-2007 03:04 AM

All times are GMT -4. The time now is 09:12 AM.