Here is the query to view all the tables of the currently connected database
SELECT * FROM information_schema.tables;
The following query can be used to show only tables from a particular database
SELECT TableName
FROM <Database_NAME>.INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
In case you are interested in SQL, then sign up for this SQL training course by Intellipaat that provides self-paced videos, instructor-led training, and also certification along with hands-on experience.
Also, watch this video on SQL to understand more: