Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

One table how may column and Primary key

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


Please Help Members By Posting Answers For Below Questions

Which tcp/ip port does sql server run on? How can it be changed?

1044


What is dbcc?

1145


What is the difference between the 2 operating modes of database mirroring?

1114


Where do we use trace frag?

1022


What do you understand by mirroring and mention the advantages of the mirroring?

1068


How many instances per computer are there in sql server 2000?

1081


How to insert stored procedure result into temporary table?

1018


Is ssrs support other database except ms sql server?

142


is there a column to which a default can't be bound? : Sql server database administration

1016


You want to implement the one-to-one relationship while designing tables. How would you do it?

966


Do you know what is xpath?

1092


What is the Control Flow in SSIS

1095


How many types of the database links?

1071


What are the functions in sql server?

952


What are different types of schemas?

947