In contrast, no checking is performed when records are added to the key columns of a parent table.
与之相反,当记录被添加到父表的键列时,不执行检查。
The parent table in the left panel shows all the parent objects of any selected object in the tree.
左面板中的父表显示了树中任何所选对象的所有父对象。
The referenced unique or primary key constraint on the parent table or view must already be defined.
引用唯一或主键约束,必须是父表中已经定义的。
Any row in the parent table can be selected to expand the tree to the location of the selected parent object.
可以选择父表中的任何行,将树扩展到所选父对象的位置。
Specifies the expression based on fields in the parent table that relates to an index in the child table.
指定基于父表中的字段而又与子表中的索引相关的表达式。
The delete rule controls how delete operations performed against a parent table in an RI relationship are processed.
Delete规则控制对RI关系中父表执行的删除操作的处理方法。
The latter is actually a primary key lookup against the parent table and constitutes the foreign key constraint verification.
索引扫描实际上是对父表进行主键查找,并完成外键约束验证。
Shows how to ensure the selected row of a child table does not change, when a change is made to a field of the parent table.
演示如何确保在更改父表的字段时,子表的选定行不会发生改变。
An update operation could change a record in a child table such that it no longer has a matching record in the associated parent table.
一个更新操作可改变子表中的一条记录,这样相关父表中不再有一条匹配的记录。
Also it is not an option to disable the constraints and I cannot cause locks on the parent table for any significant amount of time.
它也不是禁用约束的选项,我不能导致父表上的锁任何大量的时间。
Long story short, I ended up with some data in the parent table, and this should've never happened but now I have to clean up the mess.
长话短说,我结束了父表中的某些数据,这应该不会发生的但现在我要收拾残局。
ON DELETE CASCADE—When a record is deleted from the parent table, all records in the child table with matching foreign key values are also deleted.
ON DELETECASCADE —当一条记录从父表中删除时,子表中的所有记录以及匹配的外键值都全部被删除。
I have a table structure with partitioned tables, where a few child tables inherit from a common parent. How so I DELETE only from the parent table?
我与分区表有一个表的结构,其中一些孩子继承了一个共同的父表。我怎么DELETE只有从父表?
When ON delete set NULL is active, when a record is deleted from the parent table, all records in the child table with matching foreign key values are set to NULL.
当ON DELETESETNULL规则被激活时,如果一条记录从父表中删除,子表中的所有记录以及匹配的外键值都被设置为NULL。
An update operation could change a record in a parent table, leaving records in an associated child table that no longer have a matching record in the parent table.
一个更新操作可改变父表中的一条记录,使得相关子表中的记录在父表中没有与之匹配的记录。
A delete operation could remove a record from a parent table, leaving records in an associated child table that no longer have a matching record in the parent table.
一个删除操作可以从一个父表中删除一条记录,使得相关子表中的记录在父表中没有与之匹配的记录。
When an ON delete CASCADE rule is active, all records in the child table with matching foreign key values are deleted when a record is deleted from the parent table.
当ONDELETECASCADE规则被激活时,当一条记录从父表中删除时,子表中的所有记录以及匹配的外键值都被删除。
Again, you might think of a container as being a child, and a table space as its parent.
重申一次,您可以认为容器是孩子,而表空间是其父母。
Also note that the keyword categories are stored in the dimension table category, where each category points to its parent category within this table.
还需注意,关键词类别存储在维表CATEGORY中,在这个表中,每个类别指向它的父类别。
Therefore, if your source table was either a parent or child in an RI relationship, you need to capture the foreign keys definition and recreate them after the table is moved.
因此,如果源表在RI关系中为父表或子表,您需要捕捉外键定义并在移动表之后重新创建它们。
The BEGIN_EVENT_TABLE() macro takes two arguments: the class the event table is actually for and the immediate parent of that class.
BEGIN_EVENT_TABLE()宏有两个参数:事件表实际针对的类和此类的中间父类。
Table 1 lists some of the other parent proc_dir_entrys that you can use, along with their location in the filesystem.
表1列出了可以使用的其他一些父proc_dir_entry,以及它们在这个文件系统中的位置。
This second select statement is joined with the Common Table Expression (CTE) itself by linking parent to child data.
第二个SELECT语句通过将父数据链接至子数据与公共表表达式 (CTE) 联接。
The widget parent element has attributes that specify information about the widget, as shown in Table 1.
Widget父元素有详细说明Widget信息的属性,如表1所示。
You simply create a type column on your database table and inherit any subclass from the parent.
您只需在数据库表上创建一个type类,然后再从父类中继承子类即可。
Joined table: (Optional) the child class is mapped to a table that has a foreign key relationship to the table to which the parent is mapped.
联合表:(可选)将子类映射到与父类映射到的表具有外键关系的表。
Indicates whether the parent rows show labels for the table and for the columns.
指示父行是否显示表和列的标签。
The parent could take his offspring to his place of business and let him watch while he repaired a car or built a table.
父母可能带上孩子前去他上班的地方,在他修理汽车或制作桌子时让孩子在旁边看着。
For each row in the table (each location), create a new XML node with the row attributes as XML attributes, and append it to the parent node.
对于每个表中(每个位置),创建一个新的行与行的XML节点属性的XML属性,并追加到父节点。
For each row in the table (each location), create a new XML node with the row attributes as XML attributes, and append it to the parent node.
对于每个表中(每个位置),创建一个新的行与行的XML节点属性的XML属性,并追加到父节点。
应用推荐