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));