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

157 views Asked by At

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.

2

There are 2 answers

0
Andrii Horda On BEST ANSWER

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.

3
Boggio On

Have a look at SYSFKEY, it could solve your problem.