History for Question8

??changed:
-
Question 8

  Alter table Order with the addition of the deletion constraint such that 
  'deletion is restricted'.

  SQL::

    Put SQL statement here.

  Output::

    Put query result here.

<hr solid id=comments_below>


mj (Sep 17, 2001 7:28 pm; Comment #1)  --
 Q said he'd do this one.
 
mj (Sep 19, 2001 10:41 pm; Comment #2)  --
 I'd like to do this one, except that it is not clear what the constraint should apply to. Should records not be deleted? Should the ON DELETE RESTRICT apply to the foreign keys?
 
 The latter is hard unless you defined names for the foreign key constraints when creating the table, as DB2 will have defined a random name for the constraint otherwise.