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 sql does db2 use?
in procedure how to return a value
why sql is used as interpreter frequently rather than a compile?
Is it possible to update views?
What is form and report?
What is the maximum size of sqlite database?
What does partition by mean in sql?
How many aggregate functions are available there in sql?
how a reference cursor works?what all adnvantages are gained with it..specify the situation?
How do I count records in sql?
Give an example of any procedure.
5 Answers Accenture, iFlex, Wipro,
Where is pl sql used?
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)