1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

One table how may column and Primary key

Question Posted / prasad

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

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

Can we drop user if user mapped to any logins

1 Answers  

What is db stored procedure?

0 Answers  

Is a primary key unique?

0 Answers  

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers  




How to concatenate two strings in SQL Server.

0 Answers   HCL,

what is the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  

can any one please send sql quries most used in applications.

2 Answers  

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,

how to find 6th highest salary

0 Answers   Chetak Logistics,

Explain transaction isolation levels in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories