Interested to Buy Any Domain ? << Click Here >> for more details...
Can a table have two primary keys?
- 44 Answers
- 95197 Views
- HCL, MetaCube, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anand
Yes table can have two or more primary key,when we want to
create more then one primary we use unique constranit with
not null or we can create with triggre.
| Is This Answer Correct ? | 1 Yes | 6 No |
Yes table can have two or more primary key.
| Is This Answer Correct ? | 1 Yes | 9 No |
Answer / ashwin kumar
yes, a table may have more than 1 primary keys but, of them
we only choose 1 column as identifiable column called
primary key. The other columns are called surrogate keys or
candidate key.
| Is This Answer Correct ? | 25 Yes | 43 No |
Answer / jamalvalli
Yes we can use. for Example
create table emp(empno number(5), ename varchar2(20),
deptno number(5) add primary key Pk_constraint( empno,
deptno))
| Is This Answer Correct ? | 18 Yes | 38 No |
What is query optimization in sql?
Explain locks? : Transact sql
What is the use of & in pl sql?
What are operators available in sql?
What is sql and its types?
What are the different types of sql commands?
How to use sql statements in pl/sql?
can i create trigger on synonym is it possible or not please help me
How do you take the union of two tables in sql?
What is break?
What is the use of desc in sql?
Tell me what a package consists of.
-
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)
