get tables in database sql

The solution for this is noted below

SELECT
  *
FROM
  INFORMATION_SCHEMA.TABLES;

Try other methods by searching on the site. That is if this doesn’t work