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

Question

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.

score 0 · Accepted Answer · answered Dec 12 '13 at 17:10

0

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.

answered Dec 12 '13 at 17:10

Andrii Horda

170
1
16

score 0 · Answer 2 · edited Aug 14 '15 at 23:23

0

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

edited Aug 14 '15 at 23:23

durron597

31,968
17
99
158

answered Dec 19 '13 at 23:28

Boggio

1,128
11
16

Sybase IQ 15.4. It does not contain the values, that i was searching for in SYSFKEY. – Andrii Horda Dec 20 '13 at 08:10
Cannot check but you may also try: SYSIDX / SYSIDXCOL. – Boggio Dec 20 '13 at 13:46
well, the thing is that i already found where values should be. It's [SYSTRIGGER](http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc38151.1540/doc/html/saiq-systrigger-system-view.html) view. But SYSTRIGGER is empty and does not provide access to change this values – Andrii Horda Dec 20 '13 at 14:04

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

2 Answers2