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?

Answer: B. SHOW TABLES; — 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…

  1. A.

    DISPLAY TABLES;

  2. B.

    SHOW TABLES;

  3. C.

    SELECT TABLES;

  4. D.

    VIEW TABLES;

Attempted by 3039 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.

Explore the full course: Rssb Basic Computer Instructor

Loading lesson…