Answer / ramireddy

No, A table having only one primary key.
If you declare as Primary
key(<column_name>,<column_name>,<column_name>) for any
table. This type key is called as composite key.

Answer / hari

no. a table can have only one primary key.some times table
can use composite primary key

ex create table std
(stdid bigint(10) not null,
e mailid varchar(20) not null);
primary key(stdid,e mailid)

Answer / chandu

We can create only one Primary kay in a table but it can
have multiple columns, of them we only choose 1 column as
identifiable column called primary key and the other columns
are called candidate key(s).

Answer / abdul kuddus

Yes, A table can have maximum 16primary key columns in a table

Answer / venkatesh

No,why because in one table in one primary key.so can use two primary key in a table that type of key is composite primary key.

Answer / sruthi

yes table can contain one or more than one primary keys
but only one is considered as a primary key .

Answer / anup ghosh

hi gyes please removw who have writen wrong ans. One table
can have only one primary key other wise it is not a good
database design.also my knowledge says that only one tabl;e
can have only one promary key........

Answer / biju

Perfect answer Mr. Satish Reddy. Appreciated

Answer / subbu

Well the question is

Can a table have two primary keys?

Practically Yes.

But theoritically there will be only 1 primary key with
multiple foriegn keys which acts as a composite keys for the
original primary key. How ever in the create or alter
statements, we need to write primary key only once following
the column names either single or multiple.

By seeing the posts, I believe some of the guys has got
confused with the question & compared it with the SQL create
statements where in Primary Key is written only once & by
which concluding that a table cannot have multiple primary keys.

Answer / kumar navdeep shanker

Ya, it is possible..
try with this Query..
create table cust11
(
cno int not null,
balance int not null,
cname varchar(10),
CONSTRAINT cust primary key (
cno,balance)
)

If there is any Problem.. plz reply

Do stored procedures prevent sql injection?

0 Answers  

State the difference between implict and explict cursor's?

7 Answers   CTS,

What are stored procedures in mysql?

0 Answers  

What is lookup table in sql?

0 Answers  

how to get a list of all tables in a database? : Sql dba

0 Answers  

what is External tables? explain with examples

2 Answers   TCS,

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

Cite the differences between execution of triggers and stored procedures?

0 Answers  

What is keys and its types?

0 Answers  

Explain two easy sql optimizations.

0 Answers  

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

What is offset in sql query?

0 Answers