Can a table have two primary keys?
Answer Posted / kumar navdeep shanker
Ya, it is possible..
try with this Query..
create table cust11
(
cno int not null,
balance int not null,
cname varchar(10),
CONSTRAINT cust primary key (
cno,balance)
)
If there is any Problem.. plz reply
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the most restrictive isolation level? : Transact sql
Does sql support programming?
Is sql dba a good career? : SQL DBA
What do you mean by table in sql?
How does index help in query performance?
How can we make an if statement within a select statement?
What are the different types of constraints?
What is the purpose of my sql?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
How does a covering index work?
How do you update a value in sql?
What is scalar function?
What is a temporal data type?
What is materialized view in sql?
What is acid property in a database?