CREST Practitioner Security Analyst (CPSA) Practice

In MySQL, which SQL command is used to show all tables in the current database?

1. SHOW TABLES

2. SELECT * FROM information_schema.tables

3. SELECT name FROM sysobjects

4. SELECT USER()

The correct answer is: SHOW TABLES

In MySQL, the command to display all tables in the current database is indeed the 'SHOW TABLES' command. When this command is executed, it directly queries the system catalog of the current database and returns a list of the tables that exist in that database. This command is straightforward and specifically designed for quickly obtaining a list of tables without needing to write a more complex query. The other options, while they may relate to retrieving information from databases, do not serve the same purpose in the context of listing tables in MySQL. For instance, using SELECT to query the information_schema.tables is a valid method to retrieve information about tables, but it is more complex and not the most efficient or simplest approach for simply listing tables. The other options pertain to different functionalities within different database systems and contexts that do not apply to MySQL's specific requirement for listing tables. Therefore, 'SHOW TABLES' is the most appropriate and correct answer in this context.