is there more the two primary key in a single table?
- 26 Answers
- 28654 Views
- Eforce, Systematix, I also Faced
- E-Mail Answers
Answer Posted / vinay singh
There are no more than one Primary Key in a single table,
but we can make a Primary key using combination of more than
one column...
Example..
CREATE TABLE [LoginHist] (
[UserId] [char] (15) NOT NULL ,
[LogDate] [smalldatetime] NOT NULL ,
[ClientIp] [char] (15) NOT NULL ,
[LoginCount] [int] NULL DEFAULT (0),
CONSTRAINT [PK_LoginHist] PRIMARY KEY CLUSTERED
(
[UserId],
[LogDate],
[ClientIp]
) ON [PRIMARY]
) ON [PRIMARY]
** Vinay Singh
** Cell No - 9867774724
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
How can you find out how many rows returned in a cursor?
What is de-normalization and what are some of the examples of it?
What is the use of for clause?
Do you think BCNF is better than 2NF & 3NF? Why?
What are the different types of backups that exist?
What is store procedure?
How to grant a permission in ms sql server using "grant execute" statements?
What are null values in ms sql server?
What is the default server name for sql server?
How many triggers are possible per table?
What are the steps to process a single select statement?
How to view existing indexes on an given table using sys.indexes?
what is denormalization? : Sql server database administration
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
How to disable a login name in ms sql server?
