What is the maximum length of each type of identifier in MySQL?

MySQL MySQLi Database

As we know that certain objects within MySQL are known as identifiers. These objects include a database, table, index, column, alias, view, stored procedure, partition, tablespace etc. Identifiers are stored using Unicode (UTF-8). The maximum length of each type of identifier is given in the following table:

Sr. No.	Identifier	Maximum Length (characters)
1	Database	64
2	Table	64
3	Column	64
4	Index	64
5	Constraint	64
6	Stored Procedure or Function	64
7	Trigger	64
8	View	64
9	Event	64
10	Tablespace	64
11	Log File Group	64
12	Alias	256
13	Compound Statement Label	16

Smita Kapse

Published on 20-Feb-2018 11:42:22

Previous Page Print Page