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??????
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 difference between sql and mysql?
What's the difference between a primary key and a clustered index?
what are the advantages and disadvantages of views in a database? : Sql dba
tell me about various levels of constraint. : Sql dba
Why is partition used in sql?
What is sql procedures and functions?
Write an sql query to select all records from the table?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
How can you fetch first 5 characters of the string?
Do we need commit after truncate?
What are character functions?
What is oracle pl sql developer?
Show how functions and procedures are called in a pl/sql block.
What normalization means?
How to add a column ‘salary’ to a table employee_details?