I want to check that I'm doing this right.
The second ON DELETE CASCADE, it'll enact when a people(id) entry is deleted?
So
IOW, when an id from the table people is deleted, any table entries from
notes_to_the_record_shared that are related to this people id will also be
deleted.
create table notes_to_the_record_shared (
n_r_shared_id NUMBER Primary Key,
n_r_id NUMBER REFERENCES notes_to_the_record(n_r_id) ON DELETE
CASCADE,
id NUMBER REFERENCES people(id) ON DELETE CASCADE
)
thanks and good windy morning (from here)
daniel
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266971
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
