Interested to Buy Any Domain ? << Click Here >> for more details...
is there more the two primary key in a single table?
- 26 Answers
- 33378 Views
- Eforce, Systematix, I also Faced
- E-Mail Answers
Answer Posted / sivakumar
No, When creating table using script we can create primary
key another one is called composite key that means
combination of more than
one column...
CREATE TABLE [LoginHist] (
[LogDate] [smalldatetime] NOT NULL ,
[ClientIp] [char] (15) NOT NULL ,
[LoginCount] [int] NULL DEFAULT (0),
CONSTRAINT [PK_LoginHist] PRIMARY KEY CLUSTERED
(
[LogDate],
[ClientIp]
) ON [PRIMARY]
) ON [PRIMARY]
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to use linked server?
What are indexes in sql?
Why olap is used?
What are the tables in sql?
What are the differences between ms sql server & oracle?
How to insert new line characters into strings?
How to create a large table with random data for index testing in ms sql server?
What are the advantages of using third-party tools?
Explain the difference between clustered and non-clustered index?
How would you add a section to a table?
What is the purpose of the model database?
Why SQL Agent is used?
Do you know sql server 2008 introduces automatic auditing?
What is sqlcmd?
What is report server project?
