If we declare constraints Unique and Not null on a single
column then it will act as a Primary key, so what is the use
of primary key??
Answer Posted / ashok
Internally , There is same as primary key and unique not null.
You can say unique + not null is higher step of primary key .
So there is no basic difference between this two.
| Is This Answer Correct ? | 7 Yes | 11 No |
Post New Answer View All Answers
what is the functionality of the function htmlentities? : Sql dba
Can we delete column in sql?
What is full join in sql?
What type of database is cloud sql?
Is mariadb nosql?
What are sql procedures?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
what is a database transaction? : Sql dba
Write a query to display the current date in sql?
What is $$ in sql?
What are tables and fields in the database?
Is left join same as join?
how to extract a unit value from a date and time? : Sql dba
What are the different dcl commands in sql?