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 |
Is it possible for a stored procedure to call itself or recursive stored procedure?
What do mean by xml datatype?
Write an sql query to find first weekday of the month?
How to recreate an existing index in ms sql server?
How much memory that we are using in Logshipping Concept?
What is the difference between a clustered index and a non-clustered index?
What is lookup override?
What is the default sql server instance name?
what is hash nonclustered index
how would you improve etl (extract, transform, load) throughput?
How to transfer data from a cursor to variables with a "fetch" statement?
What does the automatic recovery do?