LineAsStringWithNamesAndTypes - ClickHouse Documentation

Input	Output	Alias
✗	✔

Description

The LineAsStringWithNames format is similar to the LineAsString format but prints two header rows: one with column names, the other with types.

Example usage

Query

CREATE TABLE example (
    name String,
    value Int32
)
ENGINE = Memory;

INSERT INTO example VALUES ('John', 30), ('Jane', 25), ('Peter', 35);

SELECT * FROM example FORMAT LineAsStringWithNamesAndTypes;

Response

name    value
String    Int32
John    30
Jane    25
Peter    35

Format settings

Last modified on July 2, 2026

MarkdownDocumentation for the Markdown format

​Description

​Example usage

​Format settings

Description

Example usage

Format settings