Skip to main content

Documentation Index

Fetch the complete documentation index at: https://private-7c7dfe99-page-updates.mintlify.app/llms.txt

Use this file to discover all available pages before exploring further.

InputOutputAlias
✗✔

​
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

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