How many Primary keys and Primary Indexes can we create on a table.How many Foreign keys and Secondary indexes can we create on a table.How many maximum columns can we create in a table

ASHOK PANGULURI

• Feb 11th, 2012

Every table can contain only one primary key, automatically ONE primary index also created.

Multiple foreign keys are containable in a table depending upon the relations of other table. No foreign key indexes are automatically created.

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Jan 12th, 2012

Maximum one primary key and one primary index
foreign key depends on the primary key. You cannot create many to one relationship between pk and fk.
There are maximum 1000 columns we can create in a table.

Answer Question  Select Best Answer