Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


is there more the two primary key in a single table?

Answers were Sorted based on User's Feedback



is there more the two primary key in a single table?..

Answer / sandesh kadam

No,

Is This Answer Correct ?    34 Yes 12 No

is there more the two primary key in a single table?..

Answer / 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

is there more the two primary key in a single table?..

Answer / sandesh kadam

Guys,

Saying "yes", can you please make efforst in explaining how
to have two primary keys on the table.

Regards
Sandesh

Is This Answer Correct ?    12 Yes 3 No

is there more the two primary key in a single table?..

Answer / kesavan.g

Yes.

Is This Answer Correct ?    18 Yes 10 No

is there more the two primary key in a single table?..

Answer / selvaraj.v

In SQL Server 2000,

Query :
-------

create table BookDetails
(
Book_ID int identity(1,1) not null primary key,
Book_Title varchar(20),
Book_Type varchar(15),
Book_Author varchar(25),
Book_Edition float,
Book_Publisher varchar(20),
Book_Pub_Year datetime,
Book_Price int primary key
)

Answer :
--------

Server: Msg 8110, Level 16, State 1, Line 1
Cannot add multiple PRIMARY KEY constraints to
table 'BookDetails'.

Reply Answer:
-------------
So,Can't Create more Primary Keys in a Table.

Is This Answer Correct ?    13 Yes 5 No

is there more the two primary key in a single table?..

Answer / gowthami radhakrishnan

no only one primary key for a table.but primary key can be
uesd in combination with other key known as composite key.

Is This Answer Correct ?    7 Yes 0 No

is there more the two primary key in a single table?..

Answer / jahir

refer below, actually its not primary key, Its Composite Key

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]

Is This Answer Correct ?    6 Yes 1 No

is there more the two primary key in a single table?..

Answer / 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

is there more the two primary key in a single table?..

Answer / asas

NO guys

create table prk(eno int primary key, dno int primary key)


Msg 8110, Level 16, State 0, Line 1
Cannot add multiple PRIMARY KEY constraints to table 'prk'.

Is This Answer Correct ?    4 Yes 1 No

is there more the two primary key in a single table?..

Answer / vijay

No, more than one primary key in a table
but combination of more than one column in a
primary key

Is This Answer Correct ?    4 Yes 1 No

Post New Answer



More SQL Server Interview Questions

What is the command to change the recovery model?

0 Answers  


What is an etl file?

0 Answers  


why would you use sql agent? : Sql server database administration

0 Answers  


Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  


What is statement level trigger?

0 Answers  






Who is the owner of a schema in ms sql server?

0 Answers  


What is difference between sql and sql server?

0 Answers  


If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  


What is serializable?

0 Answers  


What is the fillfactor concept in indexes?

0 Answers  


How to check table values in sql server?

0 Answers  


What is the meaning of sql server?

0 Answers  






Categories