How you can see database structure and list of tables in MYSQL?

1.	How you can see database structure and list of tables in MYSQL?
Answer» In MYSQL, we can see the data STRUCTURE with the HELP of DESCRIBE command. The SYNTAX to USE this command is as follows. DESCRIBE Table name; We can see the list of all tables in MYSQL using SHOW command. The syntax to use the thing command is as follows. SHOW TABLES;

Answer»

In MYSQL, we can see the data STRUCTURE with the HELP of DESCRIBE command.

The SYNTAX to USE this command is as follows.

DESCRIBE Table name;

We can see the list of all tables in MYSQL using SHOW command.

The syntax to use the thing command is as follows.

SHOW TABLES;

Discussion