How many maximum number of fields can be there in a table?

Questions by jaichand

Showing Answers 1 - 4 of 4 Answers

Surender

  • Nov 20th, 2007
 

Don't cross the total size of each record to 255 characters
maximum we can have 216 fields in a table
and max 16 key fields.

hope this may help you.

  Was this answer useful?  Yes

Binoy

  • Jul 19th, 2011
 

--Maximum of 16 keys are allowed in a table
--May not have more than 249 fields
--sum of all field length is limited to 1962

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions