Its possible to add more than one primary key for the table
Answers were Sorted based on User's Feedback
Answer / rajesh venati
No, it is not possible, only one primary key is possible for
a table.
It is possible to create a primary key on more than one
column in a table, up to 32 columns. It is called composite
primary key.
| Is This Answer Correct ? | 19 Yes | 2 No |
Answer / ravi singh
No, physically its not possible to add more then one primary key on a table, although logically you can create an unique key on a column and put it as not null .
| Is This Answer Correct ? | 8 Yes | 1 No |
NO its not possible to add more than one primary key in one table , but using trigger we can make another non_primary column acts as primary key column.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ramesh
No not possibble add more than one primay key on the table
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the difference between implicit and explicit trigger
How will you distinguish a global variable with a local variable in pl/sql?
What are reports usually used for?
What are schema-level triggers?
What does t sql mean?
How do you change a value in sql?
What is sql select statement?
How many sql core licenses do I need?
What is crud diagram?
Is sql better than excel?
What is materialized view in sql?
What is cursor explain with example?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)