RowGenerator table (dbo)

The dbo.RowGenerator table is provided as a read-only table that has 255 rows. This table can be useful for queries which produce small result sets and which need a range of numeric values.

The RowGenerator table is used by system procedures and views, and should not be modified in any way.

You can also use the sa_rowgenerator system procedure to generate a range of numeric values. For more information about using the sa_rowgenerator system procedure, including examples, see sa_rowgenerator system procedure.

Column name Column type Column constraint Underlying table constraints
row_num SMALLINT NOT NULL

row_num   A value between 1 and 255.