Difference question on SQL Server

Question

1.00/5 (3 votes)

See more:

My Question is
What is the difference between index and unique index?

Anwer my question as soon as possible.
Thank You.

Posted 27-Feb-13 1:21am

NeenaM

Add a Solution

Comments

CHill60 27-Feb-13 7:41am

To get an answer as soon as possible you should update your question to add some more detail about what you really mean OR do some research in google (e.g. search for sql difference between index and unique index) then update your question when you have a more specific problem

Sergey Alexandrovich Kryukov 1-Mar-13 10:54am

Look at other questions, they all spam like that. Why are people answering. And OP is a cheater: please see the "answer" above.
I'll have to report in abuse forum.
—SA

Sergey Alexandrovich Kryukov 1-Mar-13 10:53am

Spam and incorrect type of question.
—SA

NeenaM 2-Mar-13 9:52am

why this question is incorrect

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mike Meinz · Accepted Answer · 2013-02-27T01:46:00

Solution 1

A UNIQUE index guarantees that the index key (one or more columns) contains no duplicate values and therefore every row in the table is in some way unique. See Create Unique Indexes[^].

An index that is not unique is built using one or more key columns that may be the same in more than one row of the table that is indexed.

Posted 27-Feb-13 1:46am

Mike Meinz

Comments

NeenaM 27-Feb-13 9:35am

Thank you Mike