Which of the following will display a list of tables in a database?
2023
Which of the following will display a list of tables in a database?
- A.
DISPLAY TABLES;
- B.
SHOW TABLES;
- C.
SELECT TABLES;
- D.
VIEW TABLES;
Attempted by 2389 students.
Show answer & explanation
Correct answer: B
To display the list of tables in a database (commonly in MySQL), the correct SQL command is: SHOW TABLES; DISPLAY TABLES; ❌ → Not a valid SQL command SELECT TABLES; ❌ → Incorrect syntax VIEW TABLES; ❌ → Not a valid SQL command
A video solution is available for this question — log in and enroll to watch it.