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
- 10174 Views
- rsystems, I also Faced
- E-Mail Answers
Answer Posted / john
primary key will not allow null values.but in case of
unique,more than one null value s accepted.
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What trigger means?
Explain commit, rollback and savepoint.
what is sub-query? : Transact sql
Why stored procedures are faster than query?
What is pivot table in sql?
Can we use commit inside a trigger?
Is sql developer case sensitive?
What is data definition language?
What is the difference between numeric and autonumber?
How is debugging done?
what is a control file ? : Sql dba
What is synchronized subquery?
What are the key differences between SQL and PL SQL?
How can you select unique records from a table?
What is 19 null in sql?
