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
explain mysql aggregate functions. : Sql dba
Can a select statement fire a trigger?
How do I count rows in sql?
What steps server process has to take to execute an update statement?
What is 19 null in sql?
What is dbo in sql?
What is the difference between rename and alias?
Can we use view in stored procedure?
Does a primary key have to be a number?
Which is faster view or stored procedure?
What is raid? How does it help storage of databases?
What is difference between inner join and self join?
Are pl sql variables case sensitive?
what is 'trigger' in sql? : Sql dba
What is the difference between an inner and outer join?