Can a table have two primary keys?
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
What is a memo field?
Do ddl statements need commit?
What is coalesce sql?
What is the advantage of nosql?
which tcp/ip port does sql server run on? : Sql dba
what are the different type of normalization? : Sql dba
Why do we use %rowtype & %type in plsql?
Does sql full backup truncate logs?
what are tables and fields? : Sql dba
Describe sql comments?
How long it takes to learn pl sql?
Is truncate ddl or dml?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is a full join sql?
How do I install sql?