Answer Posted / 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 |
Post New Answer View All Answers
What are the advantages of using stored procedures in sql server?
What is the difference between a unique key and primary key?
How to use transact-sql statements to access the database engine?
 Explain what is sql override for a source taLle in a mapping?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is tabulation?
what is the maximum size of a row? : Sql server database administration
How to include date and time values in sql statements?
What is read uncmmited?
can any body tell me how to know the password of current user in sql server
Explain sub-query?
What is the Main Difference between ACCESS and SQL SERVER?
What is the difference between writing data to mirrored drives versus raid5 drives
How to scale out a federation by Sql statement?
How to execute multiple stored procedures at one time in sql server?