...
In addition to the constraints above, particular database identifier types have additional constraints. Maximum lengths were initially derived from the MySQL manual. While some of these restrictions are not mandatory, following them to the letter will help ensure database portability.
maxlength: 255 characters
Identifier Type | Max length (characters) | Example |
---|---|---|
database/schema | 64 | |
table | 64 | |
column | 64 | |
index | 64 | |
view | 64 | |
alias | 255 |