|
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 on 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.