Can a table have two primary keys?

Answer Posted / 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)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to set up sql*plus output format in oracle?

781


Which command is used to call a stored procedure?

725


What is query syntax?

730


Explain the the update statement in sql?

782


Which is better varchar or nvarchar?

755


How does cross join work in sql?

721


What is sql mysql pl sql oracle?

792


How can we store rows in PL/SQL using array?

898


give the syntax of grant and revoke commands? : Sql dba

817


Does sql*plus also have a pl/sql engine?

787


What is rownum in sql?

775


name 3 ways to get an accurate count of the number of records in a table? : Sql dba

802


What is sql injection owasp?

742


What is the use of <> sql?

748


which types of join is used in sql widely? : Sql dba

731