Syntax:
SHOW CREATE TABLE tbl_name

Shows the CREATE TABLE statement that creates the named table. To use
this statement, you must have some privilege for the table. This
statement also works with views.

SHOW CREATE TABLE quotes table and column names according to the value
of the sql_quote_show_create option. See
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html.

When altering the storage engine of a table, table options that are not
applicable to the new storage engine are retained in the table
definition to enable reverting the table with its previously defined
options to the original storage engine, if necessary. For example, when
changing the storage engine from InnoDB to MyISAM, InnoDB-specific
options such as ROW_FORMAT=COMPACT are retained.

When creating a table with strict mode disabled, the storage engine's
default row format is used if the specified row format is not
supported. The actual row format of the table is reported in the
Row_format column in response to SHOW TABLE STATUS. SHOW CREATE TABLE
shows the row format that was specified in the CREATE TABLE statement.

URL: https://dev.mysql.com/doc/refman/5.7/en/show-create-table.html

