************CALLING SQL AND ORACLE EXPERTS*******************************

[vijay2349]

PRMIRAY KEY AND UNIQUEUE INDEX KI DIFFERENCE ENTI??

[vijay2349]

sSa_j@il

[stewiegriffin]

question ardam avvala...
unique key ki index untaada..???
clustered and non clustered index untai ga sCo_^Y sCo_^Y

[sombarey]

ltt

[vijay2349]

[quote author=stewiegriffin link=topic=202203.msg2466348#msg2466348 date=1307924841]
question ardam avvala...
unique key ki index untaada..???
clustered and non clustered index untai ga sCo_^Y sCo_^Y
[/quote]
CREATE UNIQUE INDEX index_name
ON table_name (column_name)

[CheGuevara]

a superb website to answer all your questions.....its only for oracle but it answers this question


[url=http://asktom.oracle.com/pls/asktom/f?p=100:11:2980497779515547::::P11_QUESTION_ID:4941517587762]http://asktom.oracle.com/pls/asktom/f?p=100:11:2980497779515547::::P11_QUESTION_ID:4941517587762[/url]

Naaku telsina oke difference, primary key doesn't allow null values but the column on which we create the unique index may have one null value.....i am not sure about it....

[stewiegriffin]

[quote author=SOURYAM link=topic=202203.msg2466353#msg2466353 date=1307924912]
CREATE UNIQUE INDEX index_name
ON table_name (column_name)
[/quote]
unique indexes comes under non clustered index category...
the column shouldn't have null values to be declared as unique index..
primary keys are generally clustered indexes
not sure though

[vijay2349]

[quote author=CheGuevara link=topic=202203.msg2466366#msg2466366 date=1307925079]
a superb website to answer all your questions.....its only for oracle but it answers this question


[url=http://asktom.oracle.com/pls/asktom/f?p=100:11:2980497779515547::::P11_QUESTION_ID:4941517587762]http://asktom.oracle.com/pls/asktom/f?p=100:11:2980497779515547::::P11_QUESTION_ID:4941517587762[/url]

Naaku telsina oke difference, primary key doesn't allow null values but the column on which we create the unique index may have one null value.....i am not sure about it....
[/quote]

the only difference is primary doesnot allow null values where other one llows anthena..but both provides unique values. #4H# #4H#

[YashKing]

[quote author=SOURYAM link=topic=202203.msg2466382#msg2466382 date=1307925300]
the only difference is primary doesnot allow null values where other one llows anthena..but both provides unique values. #4H# #4H#
[/quote]Primary key clustered index (oka clustered index ee untundi per table) whereas unique key forms non clustered index...

PK dont allow NULL whereas Unique key can allow nulls....

storage difference untundi internal ga ee keys ki

[stewiegriffin]

[quote author=Emperor link=topic=202203.msg2466388#msg2466388 date=1307925421]
Primary key clustered index (oka clustered index ee untundi per table) whereas unique key forms non clustered index...

PK dont allow NULL whereas Unique key can allow nulls....

storage difference untundi internal ga ee keys ki
[/quote]
@gr33d @gr33d
nenu tappu type chesa

[vijay2349]

thankyou thankyou thankyou all.naaku difference telisindi