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
Which tcp/ip port does sql server run on? How can it be changed?
What is dbcc?
What is the difference between the 2 operating modes of database mirroring?
Where do we use trace frag?
What do you understand by mirroring and mention the advantages of the mirroring?
How many instances per computer are there in sql server 2000?
How to insert stored procedure result into temporary table?
Is ssrs support other database except ms sql server?
is there a column to which a default can't be bound? : Sql server database administration
You want to implement the one-to-one relationship while designing tables. How would you do it?
Do you know what is xpath?
What is the Control Flow in SSIS
How many types of the database links?
What are the functions in sql server?
What are different types of schemas?