The SHOW DATABASE; query will display all the tables. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

The SHOW DATABASE; query will display all the tables.

True or false

21st Nov 2018, 2:02 PM
Dhanjit D Ray
Dhanjit D Ray - avatar
3 Answers
+ 1
False SHOW DATABASES will return all the database names. If you want to display all the tables connect to a database and run SHOW TABLES;
21st Nov 2018, 2:47 PM
Prokopios Poulimenos
Prokopios Poulimenos - avatar
0
false SHOW DATABASE; Will show the names of all databases but not the all tables . To show the table u should run SHOW TABLES; query
26th Nov 2018, 6:47 PM
Smashing Solo
0
False
27th Sep 2019, 6:53 PM
Madhuri Prasad
Madhuri Prasad - avatar