Re: Rowid Question

Posted in 1992

Rory Martin — Sun, 27 Sep 92 20:27:49 EDT — source: Informix-list mailing list archive (1991-1998)

> My simple question is: > > If you 'load' a new table from a previously 'unloaded' file > are the rowids always reassigned sequentially starting with 1? (i.e., > each added record will have rowid numbers 1,2,3,4,...,n). > The simple answer is...yes. Rowids are simply physical positions within the table. They have no other relationship with a record. They are also reassigned within the same table if a record has been deleted and another inserted. -- Rory Martin Internet: dksl2vq@bell-atl.com Bell Atlantic Network Services 2221-L Broadbirch Drive Voice: 1+ (301) 989-5075 Silver Spring, MD 20904-1985 "No matter where you go, there you are." ---------------------------------------------------------------------------