what is the different between unique+not null & primary key,
- 4 Answers
- 6366 Views
- I also Faced
- E-Mail Answers
Answer Posted / sreekumar
In a relation, we can create only one primary key where as we can create multiple unique+not null constrains.
Primary key uses clustered index where are unique +Not null uses non clustered index.
Sreekumar
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
How to disable a trigger name update_salary?
how to rename an existing column in a table? : Sql dba
What is a Mapplet?
What does count (*) do in sql?
What is java sql drivermanager?
what are string data types? : Sql dba
What is the difference between join and natural join?
Does execute immediate commit?
What is normalization? How many normalization forms are there?
What is difference between left and right outer join?
What is the sql case statement?
How do you clear the screen in sql?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What is sqlca in db2?
what are the 'mysql' command line options? : Sql dba
