Interested to Buy Any Domain ? << Click Here >> for more details...
Can a table have two primary keys?
- 44 Answers
- 98056 Views
- HCL, MetaCube, I also Faced
- E-Mail Answers
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 a cursor? : Sql dba
How to add new employee details in an employee_details table with the following details
Which are the different character-manipulation functions in sql?
What is the difference between sum and count in sql?
What is data abstraction in sql?
What is the difference between alter trigger and drop trigger statements?
What is synonyms?
how to use regular expression in pattern match conditions? : Sql dba
Can we use join in subquery?
Does view contain data?
What is the difference between a primary key and a unique key?
What is partition by in sql?
How do I upgrade sql?
How many disk partitions should I have?
how to drop an existing table in mysql? : Sql dba
