Search code examples
sqlsap-iqdatabase-metadata

What is the location of Update and Delete constraint values in Sybase IQ?

In MS SQL @DB_Name.sys.foreign_keys keeps this values in (update|delete)_referential_action columns. Where can I find them in Sybase IQ? Do values equal to MS SQL indexes/values? Thank you.

MS:
0 = No action
1 = Cascade
2 = Set null
3 = Set default

I am using Sybase IQ 15.4.

UPDATE: I found referential_action column from "SYSTRIGGER" view, but it doesn't contain any records for my foreign keys.

Solution

  • Well, looks like IQ does not have such mechanism and referential_action options described on this page is possibly does not relate to IQ directly but is a part of ASE or other product.