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
There can be only one primary key (PK) in a table but There can be many Foreign Key (FK), the current recommended number is 253 to FKs but it will cause performance issue for each update, delete, select etc. thus I suggested you that don't use many PKs
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.
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.
Maximum PK's and PI's
How many Foreign keys and Secondary indexes can we create on a table.
How many maximum columns can we create in a table
Questions by kiranparsha