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 |
What is the primary use of the model database?
How to create a new schema in a database?
Explain the functionalities that views support?
What is the difference between commit and rollback?
What is the difference between functions and stored procedures?
What is co-related sub query?
What are user defined datatypes and when you should go for them?
what is raid? : Sql server database administration
What are the pre-defined functions in the sql server?
What are the different SQL Server Versions you have worked on?
Tell me about builtinadministrator?
Explain transaction server distributed transaction?