Hi, Unique key with not null constraint works similar to the Primary key. Both will uniquely identify each row of the table with not null constraint. The only difference is a table may have arbitrarily many unique keys but at most one primary key.
-- Kind Regards Ishan Aggarwal [image: Aricent Group] Presidency Tower-A, M.G.Road,Sector-14 Gurgaon,Haryana.122015 INDIA Phone : +91-9654602663 [email protected] <[email protected]> On Sun, Sep 4, 2011 at 12:17 PM, sarath prasath <[email protected]>wrote: > what is the difference in this.. > we have a table which has one primary key and one unique key with not > null constraint.. > so r they equal...???? > > -- > You received this message because you are subscribed to the Google Groups > "Algorithm Geeks" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/algogeeks?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Algorithm Geeks" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/algogeeks?hl=en.
