show all foreign keys - SQL Anywhere

Question

Can anyone tell me how to list all the foreign keys in a SQL Anywhere database ?

Answer 1

Take a look at the SYS.SYSFOREIGNKEYS system table. It lists the primary table, foreign table, foreign key name, and the column(s) involved.

Disclosure: I work for SAP in SQL Anywhere engineering.