---
title: Generate Tables Using sys.dummy
slug: eQa8_WCeT-x7VzvF5pqpT
description: Understand how to create sample tables in Ocient with sys.dummy, a helpful tool for testing and learning SQL syntax.
docTags: 
createdAt: Wed Jul 12 2023 19:48:53 GMT+0000 (Coordinated Universal Time)
updatedAt: Wed Apr 22 2026 20:40:14 GMT+0000 (Coordinated Universal Time)
---

`sys.dummy` is a virtual table that the Ocient Data Intelligence Platform™ generates with a specific number of rows. This table is a handy tool to quickly create tables for testing without scripting extensive DDL statements.&#x20;

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

`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. &#x20;

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

:::hint{type="info"}
`SELECT *` queries that lack a `FROM` clause automatically reference the `sys.dummy1` table.&#x20;

For example, `SELECT *;` is the same as `SELECT * FROM sys.dummy1;`.
:::

**Syntax**

```sql
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.&#x20;

```sql
SELECT * FROM sys.dummy10; 
```

*Output:&#x20;*

```sql
c1
---
1
2
3
4
5
6
7
8
9
10
```

## Related Links

[General SQL Syntax](<././General SQL Syntax.md>)

[SQL Reference](<./././SQL Reference.md>)
