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?