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
What is the basic form of sql query?
Which join condition can be specified using on clause?
what is an alias command? : Sql dba
What is pl sql code?
Is sql a dbms?
What is the difference between delete and truncate commands?
What is the meaning of disabling a trigger?
What is the difference between function, procedure and package in pl/sql?
What is clause?
What is ttitle and btitle?
What are the different parts of a package?
What are sql objects?
How many types of primary keys are there?
Why procedure is used in sql?
How does rowid help in running a query faster?