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
Explain the difference between triggers and constraints?
what is column? : Sql dba
What is rank dense_rank and partition in sql?
What is primary key in db?
How do you declare a user-defined exception?
Is sql dba a good career? : SQL DBA
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Define implicit and explicit cursors.
Explain the uses of a database trigger?
What is the difference between rename and alias?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is oracle sql called?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Which is faster view or stored procedure?
what are the differences between require and include, include_once and require_once? : Sql dba