3

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

WinSupp
  • 361
  • 2
  • 6
  • 20

1 Answers1

3

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.

Graeme Perrow
  • 56,086
  • 21
  • 82
  • 121