Syntax:
SHOW CREATE TABLE tbl_name

Shows the CREATE TABLE statement that creates the given 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://mariadb.com/kb/en/server-system-variables/.

URL: https://mariadb.com/kb/en/show-create-table/

