content_image/815998.jpg content_image/816008.jpg content_image/816009.jpg
<img src='content_image/815998.jpg'>

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_verbosity 

<img src='content_image/816008.jpg'>

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. 

• show_old_temporals 

<img src='content_image/816009.jpg'>

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 

