how to get the tables in an sql database code example

Example: get tables in database sql

SELECT
  *
FROM
  INFORMATION_SCHEMA.TABLES;