After registering a table with a geodatabase, I can see in the sde.sde_table_registry table that the table was registered and that the table also has the objectid column added and populated. However, when I try to search for the sequence under the name 'r + <registration_id>', I can only find the 'r + <regsitration_id> + _sde_rowid_uk' index.
In oracle, I am able to find the sequence as expected.
Is there a query that someone can send me to definitively check for the sequence? I am searching in
pg_class
and
information_schema.sequences