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

MySQLMySQLi 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)
1Database
64
2Table64
3Column64
4Index
64
5Constraint
64
6Stored Procedure or Function
64
7Trigger
64
8View
64
9Event
64
10Tablespace
64
11Log File Group
64
12Alias
256
13Compound Statement Label
16
raja
Published on 20-Feb-2018 07:12:22
Advertisements