Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why not have comment on sequnce?

BEDEJul 6 2018

For easier documenting the database. Like we have coment on table, wouldn't it be good to have comment on sequence?

Like:

comment on sequence x_sequence is 'used for x_table.id column'

;

I know that we may have comment on x_table.id is 'primary key populated using sequence' and that in 12c there is the possibility to associate a sequence to a given column. But what if, for some reason, a given sequence is used in different ways that are would not be so straightforward?

Comments
Post Details
Added on Jul 6 2018
6 comments
786 views