Generate Tables Using sys.dummy

sys dummy is a virtual table that the {{ocienthyperscaledatawarehouse}} 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} parameter description {n} t he 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 c reate a table with 10 rows select from sys dummy10; output c1 \ 1 2 3 4 5 6 7 8 9 10 related links docid\ qcf0x9ao4a56x id39pkr docid\ twelobi0rarxjfiot1a70