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 is a constant or literal in ms sql server?
How do users use Report Builder with SQL Server data sources?
Explain transaction server auto commit?
optimization techinques
Can binary strings be converted into numeric or float data types?
What is an expression in ms sql server?
What is #temp and @table variable in SQL server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is the difference between join and inner join?
What is a db view?
Detail about query optimizer?
How can you insert values in multiple rows using one Insert statement?
Explain system views?
What is change data capture (cdc) in sql server 2008?
What is multi-statement table-value user-defined function?