> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://ocient.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://ocient.ferndocs.com/_mcp/server.

# Generate Tables Using sys.dummy

> Understand how to create sample tables in Ocient with sys.dummy, a helpful tool for testing and learning SQL syntax.

`sys.dummy` is a virtual table that the Ocient Hyperscale Data Warehouse™ 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.

**Syntax**

```sql
sys.dummy{N}
```

| **Parameter** | **Description**                                                                                                                                                                                                                                                                                                                                |
| ------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `{N}`         | The number of rows for `sys.dummy` to generate. 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. Do not specify curly brackets with this parameter in queries. |

**Example**

Create a table with 10 rows.

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

*Output:*

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

## Related Links

[**General SQL Syntax**](/guides/query-ocient/general-sql-syntax)

[**SQL Reference**](/guides/sql-reference)