Question

Write SQL statements to view names of all the tables contained in the current database?

IT IS FOR 25 POINTS!!!

WHO WILL ANSWER FAST I WILL MARK HIS/HER ANSWER AS BRAINLIEST ANSWER!!

HURRY UP!

Answer 1

mysql> SELECT table_name FROM information_schema.tables WHERE table_type = 'base table' AND table_schema='test';+------------+| TABLE_NAME |+------------+| department || employee   || role       || user       |+------------+4 rows in set (0.00 sec)
mysql> SHOW tables;+----------------+| Tables_in_test |+----------------+| department     || employee       || role           || user           |+----------------+4 rows in set (0.00 sec)