A

Admin • 831.35K Points
Coach

Q. Which command lists all views in a database?

  • (A) SHOW TABLES;
  • (B) SHOW VIEWS;
  • (C) SHOW FULL TABLES WHERE Table_type = 'VIEW';
  • (D) LIST VIEWS;
Explanation by: Admin
MySQL identifies views using SHOW FULL TABLES WHERE Table_type = 'VIEW'.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.