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 Location: Hyderabad Posts: 24 Thanks: 1 Thanked 4 Times in 2 Posts

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 2 Users Say Thank You to nageshkota For This Useful Post:

apkanuru, R.Santhosh kumar

Sponsored Links

#2 (permalink)   05-20-2008

debasisdas Moderator   Join Date: Jun 2007 Location: Bangalore,India Posts: 1,365 Thanks: 7 Thanked 123 Times in 111 Posts

Re: Issue please find a related discussion here.

#3 (permalink)   07-24-2008

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)   08-11-2008

nageshkota Junior Member   Join Date: Apr 2008 Location: Hyderabad Posts: 24 Thanks: 1 Thanked 4 Times in 2 Posts

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

#5 (permalink)   09-02-2008

ckarthick Junior Member   Join Date: Feb 2008 Location: chennai Posts: 5 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Issue table can have only one clustered index, and it can have more than one non-clustered index

#6 (permalink)   4 Weeks Ago

Amitaqa Junior Member   Join Date: Sep 2008 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts

Re: Issue one table can have one clustered index and 249 non clustered index.

Geeks Talk > Databases > SQL Server

« How to get 6th heghest salary? | HAVING CLAUSE and a WHERE CLAUSE »

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 12:18 PM.