> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8c05c8a2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Documentation for the LineAsStringWithNamesAndTypes format

# LineAsStringWithNamesAndTypes

| Input | Output | Alias |
| ----- | ------ | ----- |
| ✗     | ✔      |       |

<h2 id="description">
  Description
</h2>

The `LineAsStringWithNames` format is similar to the [`LineAsString`](/reference/formats/LineAsString/LineAsString) format
but prints two header rows: one with column names, the other with types.

<h2 id="example-usage">
  Example usage
</h2>

```sql title="Query" theme={null}
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 title="Response" theme={null}
name    value
String    Int32
John    30
Jane    25
Peter    35
```

<h2 id="format-settings">
  Format settings
</h2>