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} true 820,820 unhandled content type unhandled content type unhandled content type unhandled content type 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\ nw9vavkey2v75moxm muo docid\ zvfytm4ip4rwxsa17tvk9