> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ocient.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Generate Tables Using sys.dummy

export const OcientDataIntelligencePlatform = "OcientAIQ™ Unified Data Platform";

`sys.dummy` is a virtual table that the {OcientDataIntelligencePlatform} generates with a specific number of rows. This table is a handy tool to quickly create tables for testing without scripting extensive DDL statements.

When you execute `sys.dummy`, the database creates a table with a single column, which is automatically populated with incremental integers.

`sys.dummy` follows similar rules to a table reference. The SQL statement must specify a non-negative integer that represents the number of rows for the SQL statement to generate in the table.

In this syntax block, the `{N}` parameter represents the number of rows for `sys.dummy` to generate.

<Info>
  `SELECT *` queries that lack a `FROM` clause automatically reference the `sys.dummy1` table.

  For example, `SELECT *;` is the same as `SELECT * FROM sys.dummy1;`.
</Info>

**Syntax**

```sql SQL theme={null}
sys.dummy{N}
```

| **Parameter** | **Description**                                                                                                                                                                                                                                                                                                                                            |
| ------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `{N}`         | The number of rows for `sys.dummy` to generate. <br />The minimum numeric value for `{N}` is `0`, and the maximum is `9223372036854775807`.  This parameter must not have any leading or trailing characters. If `{N}` does not adhere to these limits, the database returns an error. <br />Do not specify curly brackets with this parameter in queries. |

**Example**

Create a table with 10 rows.

```sql SQL theme={null}
SELECT * FROM sys.dummy10;
```

\*Output: \*

```sql SQL theme={null}
c1
---
1
2
3
4
5
6
7
8
9
10
```

## Related Links

[General SQL Syntax](/general-sql-syntax)

[SQL Reference](/sql-reference)