Interested to Buy Any Domain ? << Click Here >> for more details...
Can a table have two primary keys?
- 44 Answers
- 95192 Views
- HCL, MetaCube, I also Faced
- E-Mail Answers
Answer Posted / pardeeep
NO,A table have only one primary key.But we can use it on more then one column.
Exp..
create table emp(empno int,ename nvarchar(20),deptno int,constraint Pk_constraint primary key( empno,deptno))
This query for SQL server
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can get second highest salary in sql?
Can we commit inside a trigger?
What is keys and its types?
What is sql indexing?
What is the difference between numeric and autonumber?
What are the benefits of pl/sql packages?
How many postgresql users are there, worldwide?
What is an emotional trigger?
What is before trigger?
What is the unique index?
How do you declare a constant?
What are the benefits of stored procedures?
How do you update f as m and m as f from the below table testtable?
What is program debugging?
What is a memo field?
