Table-Level Limits
Item | Max Spec (enforced) | Max Spec (recommended) | Comments |
|---|---|---|---|
Number of columns per table | 4096 | ||
Row size in bytes | 64KB | Limit does not apply to variable-length strings such as VARCHAR, VARBINARY, TEXT, etc. | |
Length of names in characters (applies to table names, column names) | 64 | ||
Number of indexes per table | 63 | ||
Number of columns per index | 32 | ||
Number of tables in a join for each SELECT | 253 |