One table how may column and Primary key
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How is sql used in sql server?
What is normalization and its forms?
4 Answers Challenger Financial,
What is the purpose of forms?
Describe the functionalities that views support.
Explain about system stored procedure?
how to retrive only second row from table in sql server 2000?
What are a scheduled jobs or what is a scheduled tasks?
What are the different Topologies in which Replication can be configured?
What is sql injection? How to protect against sql injection attack?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is deploy, process and build? : sql server analysis services, ssas
How to find the date and time of last updated table?