Can a table have two primary keys?
Answers were Sorted based on User's Feedback
Answer / suresh babu
No,The Table should have one primary key.But we can create
single primary key for combination of more columns,which is
called Composite Primary Key.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / damini
No.A table can have only one primary key .if it is having
more than one primary key then we say it as composite
primary key...A composite primarykey is a primary key of 2
or more columns together..A composite primary key is
different from primary key..
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / subbarayulu
No, a table should allows only one primary key with the
properties of NOT NULL + UNIQUE . But user can be able to
give more than one primary keys in a table with the help of
NOT NULL and UNIQUE KEYs but not directly using PRIMARY KEY
constraint.
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / srilekha
no,it's not possible to set more than one primary key column
to a single table
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / sattprakash mittal
Primary key is a field which is uniquely identified each record in a table. A table can only one primary key but there are more field can be used as primary key are known as candidate keys
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
What is rtm in testing?
I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.
Why is theta join required?
What is a sql driver?
What is a cursor for loop ?
How to read/write files from pl/sql?
What is relationship? How many types of relationship are there?
Can sql developer connect to db2?
What is %rowtype in pl sql?
wht is the difference between truncat,drop in sqlserver wht is the difference between function and stored procedure
Which is better trigger or stored procedure?
I want to execute a piece of code before calling a procedure. How to achieve it?