Article Categories

Selected Reading

UPSC IAS Exams Notes
Developer's Best Practices
Questions and Answers
Online Resume Builder
HR Interview Questions
Computer Glossary
Who is Who

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

Updated on: 2020-02-06T10:31:07+05:30

674 Views

Kickstart Your Career

Get certified by completing the course

Get Started

Previous Next