Question

26. Which command is used for show table and show the description of the table?​

Answer 1

Answer:

Hii,

Explanation:

- The structure of a table can be viewed using the DESCRIBE TABLE_NAME command. - Provides a description of the specified table or view. For a list of tables in the current schema, use the Show Tables command. - For a list of views in the current schema, use the Show Views command.

Hope it will help you....

# XxLovingBoyxX ❤️

Answer 2

Answer:

The structure of a table can be viewed using the DESCRIBE TABLE_NAME command. - Provides a description of the specified table or view. For a list of tables in the current schema, use the Show Tables command. - For a list of views in the current schema, use the Show Views command.

The MySQL's DESCRIBE or DESC both are equivalent. The DESC is the short form of DESCRIBE command and used to dipslay the information about a table like column names and constraints on column name. SHOW columns from yourTableName command.