We are migrating Informix database to oracle. Please help us to extract SYNONYM and SEQUENCE from Informix metadata using query.

1 Answer 1


Although you don't mention the version of the informix, try the ones above.

I believe that since V9.4 there is a system catalog table named SYSSEQUENCES where you can find the information about sequences on each database.

For the synonyms the one to be used is SYSSYNTABLE, if you have an older version try the SYSSYNONYMS.

  • 1
    No current version of Informix uses syssynonyms; it is a relic from the days of yore — Informix 1.10, 2.00, 2.10 — and has not been used since version 4.00 (there never was a version 3.00 for various good enough reasons at the time, and the time under discussion is 1986-1988). Commented Dec 2, 2015 at 8:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.