4.9.2.68 ROWID (extension)

Syntax

ROWID

Description

ROWID returns the row identifier of the current row in a table. This function takes no arguments. The ROWID of a row is determined when the row is inserted into the table. Once assigned, the ROWID remains the same for the row until the row is deleted. At any given time, each row in a table is uniquely identified by its ROWID.

The format of the row identifier returned by this function varies between storage managers.

Selecting a row in a table using its ROWID is the most efficient way of selecting the row. For example,

SELECT *
FROM customers
WHERE ROWID = '10';