Server System Variables Default Value OFF Enabling  show_create_table_skip_secondary_engine  causes the  SECONDARY ENGINE  clause to be excluded from  SHOW CREATE TABLE  output, and from  CREATE TABLE  statements dumped by the mysqldump  utility. mysqldump  provides the  --show-create-skip-secondary-engine  option. When specified, it enables the  show_create_table_skip_secondary_engine  system variable for the duration of the dump operation. Attempting a  mysqldump  operation with the  --show-create-skip-secondary- engine  option on a release prior to MySQL 8.0.18 that does not support the show_create_table_skip_secondary_engine  variable causes an error. For use with HeatWave. See HeatWave User Guide. SHOW CREATE TABLE  normally does not show the  ROW_FORMAT  table option if the row format is the default format. Enabling this variable causes  SHOW CREATE TABLE  to display  ROW_FORMAT  regardless of whether it is the default format. Whether  SHOW CREATE TABLE  output includes comments to flag temporal columns found to be in pre-5.6.4 format ( TIME ,  DATETIME , and  TIMESTAMP  columns without support for fractional seconds precision). This variable is disabled by default. If enabled,  SHOW CREATE TABLE  output looks like this: CREATE TABLE ‘mytbl‘ ( ‘ts‘ timestamp /* 5.5 binary format */ NOT NULL DEFAULT CURRENT_TIMESTAMP, ‘dt‘ datetime /* 5.5 binary format */ DEFAULT NULL, ‘t‘ time /* 5.5 binary format */ DEFAULT NULL ) DEFAULT CHARSET=utf8mb4 • show_create_table_verbosity • show_old_temporals Command-Line Format --show-create-table-verbosity[={OFF| ON}] System Variable show_create_table_verbosity Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF Command-Line Format --show-old-temporals[={OFF|ON}] Deprecated Yes System Variable show_old_temporals Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Boolean Default Value OFF 880