Generate Tables Using sys.dummy

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

sys.dummy{N}

Example

Create a table with 10 rows.

SELECT * FROM sys.dummy10;

Output:

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

Related Links

General SQL Syntax

SQL Reference