Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Red face Unanswered: Get All Constraints in all tables

    Hi there

    I am very new to Informix. Currently I am connected to Informix 7 from an Access database via ODBC (NewEra Informix7 driver) as a normal user. I want to bring in all tables and associated constraints to Access database from the Informix database. I can do all tables and data but I can't see any associated constraints. How do I get it?

    Alternatively, can I run a query from Access to query the Informix catalog tables to get this information? And can anyone help with the query please?

    Cheers

  2. #2
    Join Date
    Sep 2002
    Posts
    102
    You can join the systables and sysconstraints tables.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •