GET SEQUENCE NAME FOR A TABLE.
Posted on 2004-11-16
i have a question regarding to get the sequence name pertaining to a table.
say for example i have a table "Employee" with columns "eid",ename,ecity.
if eid is the primary key and i made it a auto increment sequence with name of sequence as "eid_seq"
how would i get the sequence name eid_seq using a query.
in general,if i pass in a tablename and tableowner i should get sequence name for that table.
i hvae tried using user_dependencies and to get triggers and associate triggers with sequences.but my problem was what if you have more than 1 trigger?? how would you deal that??
is there any other way to do it?
any help is appreciated.