Answer / dev

A Table can't have two primary key.

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.

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..

Answer / yes

yes

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.

Answer / srilekha

no,it's not possible to set more than one primary key column
to a single table

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

Answer / vikneswaran

no,table can have only one primary key.

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

Answer / iamanocp

A table can have only 1 primary key

What is cte?

0 Answers  

how to create object in plsql

3 Answers   Microsoft,

What is the difference between the conventional and direct path loader? : aql loader

0 Answers  

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

Explain the advantages and disadvantages of stored procedure?

0 Answers  

How can you create Cursor with parametres ?

3 Answers  

What are the triggers associated with image items?

0 Answers  

Can I learn sql in a week?

0 Answers  

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  

What mean sql?

0 Answers  

what is primary key? : Sql dba

0 Answers