ROWID Pseudocolumn

TimesTen assigns a unique id called a rowid to each row stored in a table. This rowid (called a ROWID pseudocolumn) has data type ROWID.

Condier the following:

• You can examine a rowid by querying the ROWID pseudocolumn.

• The ROWID is a pseudocolumn (not an actual column) and thus does not require database space. You cannot update, index, or drop ROWID.

• The ROWID value persists throughout the life of the table row.

• ROWID values persist through recovery, backup and restore operations. However copies of rows that are created as a result of replication or as a result of running ttMigrate to migrate rows out of the database and then back into the database or running ttBulkCp to copy rows out of the database and then back into the database have different ROWID values than the original rows.

For more information, see Expression Specification and ROWID Data Type.