Interested to Buy Any Domain ? << Click Here >> for more details...
Can a table have two primary keys?
- 44 Answers
- 96898 Views
- HCL, MetaCube, I also Faced
- E-Mail Answers
Answer Posted / pardeeep
NO,A table have only one primary key.But we can use it on more then one column.
Exp..
create table emp(empno int,ename nvarchar(20),deptno int,constraint Pk_constraint primary key( empno,deptno))
This query for SQL server
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I add a database to sql?
What is rownum?
Can you have a foreign key without a primary key?
how to drop an existing index in mysql? : Sql dba
How do I send sql query results to excel?
What normalization means?
What is a subquery in sql?
Explain the structure of pl/sql in brief.
how many sql dml commands are supported by 'mysql'? : Sql dba
Explain what is a subquery ?
What is pl sql quora?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is user in sql?
What is mutating table error?
What is partition in sql query?
