sql - How to find the sequence used for AUTO_INCREMENT? -

sql - How to find the sequence used for AUTO_INCREMENT? -

before answer, allow me emphasize question related ingres rdbms .

as many other ingres users complained in past on forums, experience access issue when auto_increment used... need find out sequence used auto_increment field, can grant access in order prevet annoying exceptions...

yes, when exception thrown (jdbc) name of sequence in question, , can prepare it. in case have bunch of tables, may want prepare them script.

how find sequence used? (i mean name)

similarly, how find out in table identity sequence used?

example: $iiidentity_sequence_0012936

try

select table_name,column_name, column_default_val iicolumns column_always_ident = 'y' or column_bydefault_ident = 'y' order 1,2

sql ingres