Skip to main content
These settings are autogenerated from source.

show_create_query_identifier_quoting_rule

Controls when identifiers are quoted in SHOW CREATE output. when_necessary (default) quotes identifiers where required to produce valid, unambiguous SQL; user_display quotes identifiers that are SQL keywords; always quotes every identifier. This setting controls whether quoting is added; show_create_query_identifier_quoting_style controls the quote characters and escaping.

show_create_query_identifier_quoting_style

Controls how quoted identifiers are written in SHOW CREATE output. Backticks (default) uses ClickHouse-style backticks, DoubleQuotes uses double quotes with ClickHouse escaping, and BackticksMySQL uses MySQL-compatible backticks where embedded backticks are doubled. This setting does not control which identifiers are quoted; use show_create_query_identifier_quoting_rule for that.
Last modified on October 9, 2026