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
- 10517 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 is top in tsql? : Transact sql
What are sql built in functions?
How to get unique records from a table?
How to get help at the sql prompt?
What operating systems are supported by oracle sql developer?
What is dml and ddl?
How to pronounce postgresql?
Explain the difference between rename and alias?
What is the size of partition table?
What is varchar sql?
What are the different parts of a package?
how do you know if your mysql server is alive? : Sql dba
Can we use update in sql function?
Where is sql database stored?
What trigger means?
