- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is the maximum length of each type of identifier in MySQL?
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 |
Published on 20-Feb-2018 07:12:22
- Related Questions & Answers
- What is the maximum length of MySQL VARCHAR column?
- What is the maximum length of a table name in MySQL?
- What is the maximum length of string in Python?
- What is the maximum length of data we can put in a BLOB column in MySQL?
- What is the maximum length of data we can put in a TEXT column in MySQL?
- What are the principles of security identifier?
- What is the default type of a hexadecimal value in MySQL?
- What is the Maximum Value of smallint(6) unsigned in MySQL?
- Maximum Length Chain of Pairs
- Maximum length of subarray such that sum of the subarray is even in C++
- What is an identifier in C language?
- Maximum Length Chain of Pairs in C++
- Maximum Length of Pair Chain in C++
- What is the type of elements of the jagged array in C#?
- What is a Virtual Circuit Identifier (VCID)?
Advertisements