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
Example
Create a table with 10 rows.
SQL
SQL