Interested to Buy Any Domain ? << Click Here >> for more details...
IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS
NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY
WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT
ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT
DUPLICATE VALUES?
SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND
PRIMARY KEY??????
- 8 Answers
- 10718 Views
- rsystems, I also Faced
- E-Mail Answers
Answer Posted / banti
Both r same :)
Primary Key= (Unique + Not Null)
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
How do you optimize a stored procedure in sql?
Are null values same as that of zero or a blank space?
How to process query result in pl/sql?
Why is %isopen always false for an implicit cursor?
What is the difference between an inner join and an outer join?
What is sql procedures and functions?
Why functions are used in sql?
How to disable a trigger name update_salary?
what does it mean to have quoted_identifier on? : Sql dba
What is a table in a database?
How do I remove duplicates in two columns?
What does pl sql developer do?
What are the operators in sql?
What's the difference between inner join and left join?
What is sqlca in db2?
