Creating a foreign key constraint with index disabled.
创建一个索引禁用的外键约束。
A relationship between the main foreign key constraint graph.
一个关系主外键约束图。
A foreign key constraint can implement referential integrity between parent and child tables.
外部索引键条件约束可于父资料表和子资料表之间,实作参考完整性。
New syntax for disabling an index for foreign key constraint was added to use with the ALTER statement.
用于为外键约束禁用索引的新语句被使用alter语句添加来使用。
In table 6, the INSERT into the Orders table fails due to a foreign key constraint violation on custno.
在表6中,对orders表执行insert语句失败,因为custno违背了外键约束。
A Foreign key constraint allows you to define referential integrity between a parent and child table.
外键约束允许您定义父表和子表之间的引用完整性。
A foreign key constraint allows you to define referential integrity between a parent and child table.
外部索引键条件约束可让您在父、子资料表之间定义参考整合性。
Delete a foreign key constraint when you want to remove the requirement to enforce referential integrity.
如果想要移除对强制引用完整性的要求,则可删除外键约束。
You cannot define a foreign key constraint in a CREATE TABLE statement that contains an AS subquery clause.
你不能在CREATETABLE语句中包含AS子查询子句定义一个外键约束。
After the foreign key constraint with index disabled is dropped and recreated, the reversion completes successfully.
终止和重新创建索引禁用的外键之后,降级就成功完成了。
Next, select the newly added foreign key constraint in the editor and specify the key columns using the Properties view.
接下来,在编辑器中选择新添加的外键约束,并使用Properties视图指定关键列。
To drop the foreign key constraint with index disabled and recreate this referential constraint, issue the following command
要终止索引禁用的外键约束,重新创建这个参考约束,执行以下命令
To do so, click on the Add icon, and then select the database object type Foreign Key Constraint, as shown in Figure 4c.
为此,单击add图标,然后选择数据库对象类型Foreign Key Constraint,如图4c所示。
The latter is actually a primary key lookup against the parent table and constitutes the foreign key constraint verification.
索引扫描实际上是对父表进行主键查找,并完成外键约束验证。
Give you the option to implement referential integrity between parent and child tables by creating a foreign key constraint.
允许您选择通过创建外键约束来实现父表和子表之间的引用完整性。
This category of overhead includes CHECK constraint verification and foreign key constraint (referential integrity (ri)) verification.
这一类的开销包括检查约束验证和外键约束(参照完整性(RI))验证。
You have an index that is associated with a Unique or Foreign Key constraint that is heavily used in queries that you want to put on SSD.
您有一个索引与Unique或Foreign Key约束关联并且该索引被大量的查询所使用,您希望将这个索引放入SSD。
When you select the type, the appropriate dialog box opens (Unique constraint or Foreign Key constraint) to help you create the constraint.
显示适当的对话框(唯一约束或外键约束),从而允许您更改约束的属性。
But from our data model's perspective, there is no unique table we can use to create our foreign key constraint, like the one between TB_RIGHT and TB_PERSON.
但是从我们数据模型的角度来看,我们没有一个惟一的表可以用来创建我们的外键约束,就像TB_RIGHT和TB_PERSON之间那样。
After converting successfully from version 11.50.xc7 to 11.70.xc1, you can use the following commands to create a foreign key constraint with index disabled.
成功地由版本11.50 .xC 7升级到11.70 .xC1之后,您可以使用以下命令,创建一个索引禁用的外键约束。
Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the truncate table operation fails.
此外,被truncate的表和其他表之间是不能有外键约束的,否则truncateTABLE操作会失败。
Syscat.tabconst Contains a row for each unique (u), primary key (p), foreign key (f), or table check (k) constraint db2 select constname, tabname, type from syscat.tabconst.
tabconst为每个唯一性(U)、主键(p)、外键(f)或者表检查(K)约束保持一个行db2select constname,tabname,typefrom syscat . tabconst。
In addition to key technologies that constraint, Machuan Wei said that China construction machinery spare parts that the gap with foreign products is another important aspect is its reliability.
除了关键技术这一制约因素,马传伟认为,中国工程机械配套件跟国外产品差距的另一个重要方面在于其可靠性上。
A foreign key is a constraint that enforces referential integrity.
外部索引键是强制使用参考完整性的条件约束。
If a dataset contains constraints (such as a foreign-key constraint) it is possible to cause exceptions to be thrown depending on the order of operations performed against the dataset.
如果数据集包含约束(如外键约束),则可能导致引发异常,取决于对数据集执行操作的顺序。
If a dataset contains constraints (such as a foreign-key constraint) it is possible to cause exceptions to be thrown depending on the order of operations performed against the dataset.
如果数据集包含约束(如外键约束),则可能导致引发异常,取决于对数据集执行操作的顺序。
应用推荐