For various reasons, mainly the need to partition some tables, we will need toalter fragment .. with rowid for some tables.  But to avoid redundancy (and maybe upsetting an existing pseudo-rowid) I need to determine which tables in a database already have "with rowid".  I know from elsewhere that when a partitioned table is "with rowid" it has an index named "system-rowid".  (That's a dash, not an underscore.), hence, this query works toward that goal:

select tabname[1,20],
       partition[1,10],
       fragtype,
     --t.tabid,
       indexname[1,20]
  from sysfragments f, systables t
 where t.tabid = f.tabid
   and indexname like "%rowid"
 order by tabname, partition
;

But I was hoping for a simpler, more direct query, like a flag in systables on systabinfo.

I will be posting a separate question of "with rowid", hopefully to remain theoretical.

Ideas, anyone?

Running the following against systables will tell you if the table has been created with rowids:

select tabname
from systables
where sysmaster:bitval(flags, 1) = 1

For various reasons, mainly the need to partition some tables, we will need toalter fragment .. with rowid for some tables.  But to avoid redundancy (and maybe upsetting an existing pseudo-rowid) I need to determine which tables in a database already have "with rowid".  I know from elsewhere that when a partitioned table is "with rowid" it has an index named "system-rowid".  (That's a dash, not an underscore.), hence, this query works toward that goal:

select tabname[1,20],
       partition[1,10],
       fragtype,
     --t.tabid,
       indexname[1,20]
  from sysfragments f, systables t
 where t.tabid = f.tabid
   and indexname like "%rowid"
 order by tabname, partition
;

But I was hoping for a simpler, more direct query, like a flag in systables on systabinfo.

I will be posting a separate question of "with rowid", hopefully to remain theoretical.

Ideas, anyone?