crosonly.blogg.se - Mysql show tables command line

Mysql show tables command line full#

Mysql show tables command line full#

See the following query: mysql> SHOW FULL TABLES FROM sakila Suppose we want to derive the list of tables with their types created in the Sakila database. To populate the list of tables with their type, we can use the FULL modifier. Output Example 3: Populate the List of Tables with its Type We are using the LIKE keyword to match the pattern.īut when we use the LIKE keyword, we cannot use the FROM modifier. Suppose we want to get the list of tables which names start with the keyword film. Example 2: Populate the List of Tables with a Specific Keyword Pattern Run the following command: mysql> SHOW TABLES FROM sakila Īs you can see, the query populated the list of the tables from the Sakila database. To view all MySQL tables created in the Sakila database, use the FULL modifier and the FROM keyword. Example 1: Show All Tables Created in Specific Database

LIKE – if you want to populate the list of tables with a specific pattern in their names, you can use the LIKE keyword.

FROM – if you want to populate the list of tables from the specific table, you can use the FROM keyword.

It can be a Base Table, a View, or the System View.

FULL – this option shows an additional column that provides the type of the table.

EXTENDED – this option populates the list of the tables that have been created by failed the ALTER TABLE statements.

Modifiers: We can use any of the following options to view the tables:.The show tables command displays the list of all tables created in a database. In this article, we are going to explore them both. Querying the Information_schema.tables table.

There are two primary methods to view the tables in MySQL: