The command used to display the DDL of certain objects
-
EXPLAIN
-
HAVING
-
SHOW
-
HELP
Reveal answer
Fill a bubble to check yourself
C
Correct answer
Explanation
The SHOW command in SQL displays the DDL (CREATE TABLE, etc.) statements used to create database objects. EXPLAIN shows the query execution plan rather than the object definition, while HAVING is used for filtering grouped results. HELP provides documentation and usage information.
AI explanation
The SHOW command (e.g. SHOW CREATE TABLE, SHOW CREATE VIEW in MySQL) is used to display the DDL statement that defines a given database object. EXPLAIN shows a query execution plan, HAVING is a filtering clause for grouped queries, and HELP just displays documentation, none of which reveal an object's DDL.