SHOW TABLES in MariaDB
The SHOW TABLES statement in MariaDB offers a list of tables that are associated with a given database. It provides an immediate and quick way to view the current list of tables that are available in the database without using complicated queries or interfaces.
Syntax of SHOW TABLES:
SHOW TABLES [FROM database_name] [LIKE 'pattern'];
Explanation:
- SHOW TABLES: This is the main clause to list the tables.
- [FROM database_name]: Indicates the name of the database from which you want to retrieve the list of tables.
- [LIKE ‘pattern’]: This is an optional clause. It allows you to filter the results based on a pattern.
Show Tables in MariaDB
MariaDB is an open-source relational database management system (RDBMS). MariaDB is a very successful RDBMS that is known for its performance, scalability, and ease of use. When dealing with databases, understanding the structure and organization of their table type becomes important. MariaDB provides several powerful storage engines like XtraDB, Aria, etc.
In this article, we will learn the SHOW TABLES command in MariaDB, along with the syntax, examples, and so on.