is there more the two primary key in a single table?
- 26 Answers
- 28632 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 will you add a dimension to cube? : sql server analysis services, ssas
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What do I need to start working with sql studio? : sql server management studio
query processing
Explain what are the database objects? : SQL Server Architecture
What is a file group?
Why should one not prefix user stored procedures with ‘sp_’?
What part does database design plays a role in performance of an sql server-based application?
What is failover clustering overview?
Is sql different from sql server?
What is triggers and its types?
What is the difference between insensitive and scroll cursor?
Give me any three differences between Truncate and Delete.
Explain different types of lock modes in sql server 2000?
Can you name some of the dml commands in sql?
