Using rowid as a Column Name

Every nonfragmented table has a virtual column named rowid. To avoid ambiguity, you cannot use rowid as a column name. Performing the following actions causes an error:
  • Creating a table or view with a column named rowid
  • Altering a table by adding a column named rowid
  • Renaming a column to rowid
You can, however, use the term rowid as a table name.
CREATE TABLE rowid (column INTEGER, date DATE, char CHAR(20));
Important: It is recommended that you use primary keys as an access method, rather than exploiting the rowid column.

Copyright© 2019 HCL Technologies Limited