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
- 8810 Views
- rsystems, I also Faced
- E-Mail Answers
Answer Posted / gazulas
if it is Primary key then we can make use foreign key in other table and can use the referential integrity concept
for unique keys we dont have that.
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
What is difference between sql and oracle?
How many types of sql are there?
Is sql a oracle?
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
Write the alter statement to enable all the triggers on the t.students table.
What is rowid in sql?
What is sql select statement?
How do I kill a query in postgresql?
How many sql databases can you have on one server?
What is difference between pls_integer and integer?
What are the topics in pl sql?
Explain constraints in sql?
What is native sql query?
what is a composite key ? : Sql dba
Describe different types of general function used in sql?
