show_create_query_identifier_quoting_rule
Controls when identifiers are quoted inSHOW 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 inSHOW 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.