Re: list of sequences

* Vishnu R (Vishnu_R@sifycorp.com) wrote:
> Is there any nice way of getting a list of sequences from a db using jdbc?

Retreive the MetaData with:
connection.getMetaData();

The DatabaseMetaData object has a method getTables, check out the
javadoc:
http://java.sun.com/j2se/1.4.1/docs/api/java/sql/DatabaseMetaData.html

When you set the types parameter to SEQUENCE you will get sequences.


Hope this helps,
Anders

--
Anders Hermansen
YoYo Mobile as