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 coalesce sql?
Can %notfound return null after a fetch?
Which nosql database is best?
Can we call stored procedure in function?
How do I count records in sql?
What is the difference among union, minus and intersect?
What is the plv (pl/vision) package offers?
What is parallel hint?
what is the difference between inner and outer join? Explain with example. : Sql dba
How can you view the errors encountered in a trigger?
What is informix sql?
What are inner outer left and right joins in sql?
How many tables can a sql database have?
How do you define a foreign key?
Can we insert data into materialized view?