All Forums Aster
zszmigiero 7 posts Joined 05/15
22 Jun 2016
How to list all seqeunces?

There is not system view to list all sequences.
I found some information inside nc_all_columns but Aster provides GRANT on sequence without simple way to identify their names.

M.Saeed Khurram 544 posts Joined 09/12
22 Jun 2016

Hi,
One possible way is to list down all the columns with serial data type from nc_all_columns.
Br,
Khurram

Khurram

zszmigiero 7 posts Joined 05/15
24 Jun 2016

Could you provide an example use this name to get next value and grant access to sequence to other user?

You must sign in to leave a comment.