is there more the two primary key in a single table?
Answer Posted / simi
yes,
CREATE TABLE [dbo].[custrate](
[id] [int] NOT NULL,
[patname] [char](50) COLLATE
SQL_Latin1_General_CP1_CI_AS NOT NULL,
[rate] [int] NULL,
CONSTRAINT [PK__custrate__12FE9D09] PRIMARY KEY CLUSTERED
(
[id] ASC,
[patname] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Tell me the difference between clustered and non-clustered index?
What is the difference between a function and a trigger?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What is your recommendation for a query running very slow? : sql server database administration
How to turn off warning messages during php execution?
ow to bring suspect mode datbase online from scratch
How to copy the tables, schema and views from one sql server to another?
Do you know the cursor types?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is the difference between system objects and user objects?
Do you know hot add cpu in sql server 2008?
What is sql server agent and what are the two modes of authentication in sql server?
What is dbcc command in sql server?
How to delete an existing row with delete statements in ms sql server?
How do I trace a query in sql server?