|
If I create a table with a cascade delete
referential integrity (foreign key), it shows as "on delete restrict", but it
does the cascade...
On another note:
create table TBL_PROPERTIES (
NAME varchar(64)
key,
TYPE varchar(16) not
null,
DEFAULT_VALUE
varchar(255)
)
create table KMS_USER_PROPERTIES (
USER varchar(64)
key,
PROPERTY_NAME varchar(64) key
references KMS_PROPERTIES on delete cascade,
PROPERTY_VALUE
varchar(255)
)
select NAME, TYPE, PROPERTY_VALUE,
DEFAULT_VALUE
from KMS_PROPERTIES left outer join
KMS_USER_PROPERTIES
on NAME=PROPERTY_NAME and LOGIN='xxx'
select NAME, TYPE, PROPERTY_VALUE,
DEFAULT_VALUE
from KMS_USER_PROPERTIES right outer join
KMS_PROPERTIES
on PROPERTY_NAME=NAME and
LOGIN=?";
|
