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.
sys.dummy is a virtual table that the 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.
SELECT * queries that lack a FROM clause automatically reference the sys.dummy1 table.For example, SELECT *; is the same as SELECT * FROM sys.dummy1;.SQL
| 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. |
SQL
SQL