Can a table have two primary keys?

Answer Posted / suresh somayajula

A table can have Only One Primary key. But a table can have
composite Primary key. that means we can create composite
primary key
upto 16 columns only.

suresh.
suresh_somayajula@hotmail.com

Is This Answer Correct ?    52 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a trigger? : Sql dba

568


What does over partition by mean in sql?

523


What is a loop in sql?

560


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

592


how to start mysql server? : Sql dba

607






How many unique keys can a table have?

546


How can you fetch common records from two tables?

583


Explain the difference between cursor declared in procedures and cursors declared in the package specification?

572


What is error ora-01000: maximum open cursors exceeded

598


Define tables and fields in a database

639


What is sqlca in powerbuilder?

556


What are secondary keys?

555


what are the non-standard sql commands supported by 'mysql'? : Sql dba

569


How does one use sql*loader to load images, sound clips and documents? : aql loader

668


Can you have more than one trigger on a table?

526