Progress
SQL-92
Guide and Reference


ROWID Function

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.

NOTE: Using its ROWID is the most efficient way of selecting the row.

SYNTAX

ROWID 

EXAMPLE

This example illustrates the ROWID function, returning all columns from the row in the customers table where the rowid = ’10’:

SELECT *
    FROM customers
    WHERE ROWID = ’10’; 

COMPATIBILITY

Progress Extension


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095