- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- 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 are the synonym statements of MySQL DESCRIBE?
Followings are the synonyms statements of MySQL DESCRIBE i.e. the statements with the help of which we can get the same kind of information/structure of the table as we get from DESCRIBE −
EXPLAIN Statement
EXPLAIN is the synonym of the DESCRIBE statement. Its syntax is also similar to the DESCRIBE statement. Consider the following example −
mysql> Explain Employee; +-------+-------------+------+-----+---------+------------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+------------------+ | ID | int(11) | NO | PRI | NULL | auto_increment | | Name | varchar(20) | YES | | NULL | | +-------+-------------+------+-----+---------+------------------+ 2 rows in set (0.11 sec)
We can see this statement also gives the same output as we got with DESCRIBE statement.
SHOW COLUMNS Statement
This statement is also a synonym of DESCRIBE and hence of statement EXPLAIN too. Its syntax is a bit different from DESCRIBE and EXPLAIN as follows −
Syntax
SHOW COLUMNS From Table_name;
Example
In the example given below, we can see that the output is the same as we have received the output from DESCRIBE and EXPLAIN statement
mysql> Show columns from employee; +-------+-------------+------+-----+---------+------------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+------------------+ | ID | int(11) | NO | PRI | NULL | auto_increment | | Name | varchar(20) | YES | | NULL | | +-------+-------------+------+-----+---------+------------------+ 2 rows in set (0.11 sec)
- Related Articles
- What is the purpose of using MySQL CHAR_LENGTH() function? Which function is the synonym of it?
- Which function is a synonym of MySQL LENGTH() function?
- What is the synonym statement of SHOW DATABASES with the help of which we can see the list of MySQL databases?
- Describe JavaScript Break, Continue and Label Statements
- What are the types of statements in JDBC?
- What are the Sources and Uses of Funds Statements?
- What kind of information is displayed by MySQL DESCRIBE statement?
- What is the use of ‘c’ option while writing MySQL statements?
- What are fossils? Describe briefly two methods of determining the age of fossils.
- What are the different types of conditional statements supported by C#?
- What are control statements in C#?
- What are label statements in JavaScript?
- What are provision in financial statements?
- What are reserves in financial statements?
- How we can get more information about columns of a table than the information we got by DESCRIBE, EXPLAIN and SHOW COLUMNS MySQL statements?

Advertisements