Which MySQL command displays all tables associated with the database ELPATRON?
A) SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_SCHEMA = 'ELPATRON');
B) SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE (TABLE_SCHEMA = 'ELPATRON');
C) SELECT * FROM USER_OBJECTS 'ELPATRON';
D) SHOW TABLES WHERE TABLE_SCHEMA = ELPATRON;

Question

Quizplus · Accepted Answer

Option A is correct because it queries the INFORMATION_SCHEMA.TABLES system view, filtering by the TABLE_SCHEMA column to list all tables within the specified database ('ELPATRON'). This is a standard method for retrieving metadata about tables in a specific database in MySQL.

Which MySQL Command Displays All Tables Associated with the Database