Lines Matching refs:table

16   the "child" table corresponds to a row in the "parent" table. For
22   implies that for each row in table "child", there must be a row in
24   is true. The columns in the parent table are required to be either the
26   requirement for the columns of the child table.
31   the child table are NULL, then there is no requirement for a corresponding
32   row in the parent table. So, taking this into account, the expression that
33   must be true for every row of the child table in the above example is
40   Attempting to insert or update a row in the child table so that the 
44   The effect of attempting to delete or update a row in the parent table 
46   table depends on the "ON DELETE" or "ON UPDATE" actions specified as
52     RESTRICT: Attempting to update or delete a row in the parent table so
54               the child table is not allowed. An exception is thrown.
56     CASCADE:  Instead of throwing an exception, all corresponding child table
62               all corresponding child table rows are set to NULL.
69       a parent table has a composite primary key, then any child table
71       the following definition of table "parent":
75       only the first of the following two definitions of table "child"
87       SET NULL foreign key are the same table, the generated triggers will
89       is indirect (for example if table A references table B which references
90       table A with a CASCADE or SET NULL foreign key constraint).
103   a foreign key that refers to a parent table that does not exist, or
104   a foreign key that refers to columns in a parent table that are not