Can a table have two primary keys?

Answer Posted / jamalvalli

Yes we can use. for Example

create table emp(empno number(5), ename varchar2(20),
deptno number(5) add primary key Pk_constraint( empno,
deptno))

Is This Answer Correct ?    18 Yes 38 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is microsoft sql free?

604


Should I use mbr or gpt?

546


Is it possible for a table to have more than one foreign key?

582


What does stand for in sql?

524


What is pl/sql language case sensitive?

635






how to create a new table in mysql? : Sql dba

548


What is the difference between the sql*loader and import utilities? : aql loader

600


Is join and inner join the same?

541


How do temporal tables work?

521


What is the basic structure of an sql?

573


what is a composite key ? : Sql dba

602


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

556


What does trigger mean in psychology?

534


How global cursor can be declare with dynamic trigger ?

1748


What are the different tcl commands in sql?

620