Can a table have two primary keys?

Answer Posted / antonis flangofas

ofc you can, stop giving to ppl wrong answers here it is

CREATE TABLE track(
album CHAR(10),
disk INTEGER,
posn INTEGER,
song VARCHAR(255),
PRIMARY KEY (album, disk, posn)
)

if you want to avoid to have id you use this way.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the basic form of sql query?

495


Which join condition can be specified using on clause?

516


what is an alias command? : Sql dba

547


What is pl sql code?

589


Is sql a dbms?

531






What is the difference between delete and truncate commands?

513


What is the meaning of disabling a trigger?

646


What is the difference between function, procedure and package in pl/sql?

560


What is clause?

608


What is ttitle and btitle?

573


What are the different parts of a package?

632


What are sql objects?

539


How many types of primary keys are there?

529


Why procedure is used in sql?

533


How does rowid help in running a query faster?

969