One table how may column and Primary key

Answers were Sorted based on User's Feedback



One table how may column and Primary key..

Answer / vignesh lakshmirajan

ONE COLUMN MAY HAVE N NUMBER OF COLUMNS,.. THERE IS NO RESTRICTION IN THAT.. BUT A TABLE SHOULD CONTAIN ONLY ONE PRIMARY KEY, BUT IT MAY HAVE N NUMBER OF UNIQUE KEYS.

Is This Answer Correct ?    12 Yes 3 No

One table how may column and Primary key..

Answer / shashi kishor prasad

In a Table there can have as many as 1024 colums but not
more than that is allowed. There can be only 1 primary key
in a table However you can combine multiple keys together to
act like a primary key that is called composite key.
Composite key is also a primary key, difference is that it
is a combination of no of colums that act as candidate key.

Is This Answer Correct ?    8 Yes 1 No

One table how may column and Primary key..

Answer / rehan khan

guys first plz check the question what is exactly asked ok

the numbers of column in a table can range from 1 to 254 and only one primary key in a table .

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How is sql used in sql server?

0 Answers  


What is normalization and its forms?

4 Answers   Challenger Financial,


What is the purpose of forms?

0 Answers  


Describe the functionalities that views support.

0 Answers  


Explain about system stored procedure?

0 Answers  






how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,


What are a scheduled jobs or what is a scheduled tasks?

0 Answers  


What are the different Topologies in which Replication can be configured?

0 Answers  


What is sql injection? How to protect against sql injection attack?

0 Answers  


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

0 Answers  


What is deploy, process and build? : sql server analysis services, ssas

0 Answers  


How to find the date and time of last updated table?

3 Answers  


Categories