Get list of tables in mysql

In this post I will share how to get the list of tables in mysql using 2 methods, the first one with the show sentence and the second with the information_schema

1. Using Show sentence

This is pretty straight forward just do the next sql query

-- Select your database
SHOW TABLES;

And then you will get the list of tables.

2. Using the information_schema

For this one we will use the information_schema.

SELECT
  TABLE_NAME
FROM information_schema.tables
WHERE
    TABLE_SCHEMA = 'our_db'

Here the our_db after the TABLE_SCHEMA is the name of our database where we want to get the list of tables.