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

> Creates a temporary table of the specified structure with the Null table engine. The function is used for the convenience of test writing and demonstrations.

# null

Creates a temporary table of the specified structure with the [Null](/reference/engines/table-engines/special/null) table engine. According to the `Null`-engine properties, the table data is ignored and the table itself is immediately dropped right after the query execution. The function is used for the convenience of test writing and demonstrations.

<h2 id="syntax">
  Syntax
</h2>

```sql theme={null}
null('structure')
```

<h2 id="argument">
  Argument
</h2>

* `structure` — A list of columns and column types. [String](/reference/data-types/string).

<h2 id="returned_value">
  Returned value
</h2>

A temporary `Null`-engine table with the specified structure.

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

Query with the `null` function:

```sql theme={null}
INSERT INTO function null('x UInt64') SELECT * FROM numbers_mt(1000000000);
```

can replace three queries:

```sql theme={null}
CREATE TABLE t (x UInt64) ENGINE = Null;
INSERT INTO t SELECT * FROM numbers_mt(1000000000);
DROP TABLE IF EXISTS t;
```

<h2 id="related">
  Related
</h2>

* [Null table engine](/reference/engines/table-engines/special/null)