null_output ​

Description ​

Emits no result bytes. The statement still executes and its constraints and request limits still apply.

Output only. Select it with FORMAT null_output. Names ignore ASCII case; use the snake_case name shown here.

No result payload is written, but SQL still executes. Use it when the result itself is unnecessary and only execution success or failure matters.

The format does not skip reads or writes, suppress constraint errors or bypass request limits. It is output-only.

SELECT expressions FORMAT null_output;

Example usage ​

SELECT CAST(7 AS Int64) AS id, 'Ada' AS name FORMAT null_output;

The result body is empty.

Format settings ​

Use a statement SETTINGS clause; these options are not persisted by SET.

There are no format-specific settings.