- Using ROWID is another way to have the system assign a unique value to a column.
- ROWID is similar to IDENTITY COLUMNS.
- But rather than being an attribute of a numeric column, it is a separate data type.
- Same as IDENTITY COLUMNS there are 2 options for GENERATED clause.
- BY DEFAULT
CREATE TABLE ORDERS (ORDERNO ROWID GENERATED ALWAYS, SHIPPED_TO VARCHAR (36) ,ORDER_DATE DATE)