如果您有一个已有约束,而且想要利用这一特性的优势,您必须删除约束,然后重新创建。
If you have an existing constraint and would like to take advantage of this feature, you must drop the constraint and re-create it.
第三,你必须删除所有可能存在的你为用户提供的操作上的约束。
Third, you have to remove all possible constraints on the operations that you provide for the user.
这可以采用添加列、更改列的数据类型、添加约束或者甚至删除列的方式来实现。
This can take the form of adding a column, changing the data type for a column, adding a constraint, or even deleting a column.
以其他方式修改数据库,包括添加、删除或修改索引或其他约束。
Changing the database in other ways, including adding, dropping, or modifying indexes or other constraints.
在DB2中运行在线备份的惟一约束是:当一个表空间正在被备份的时候,不能删除这个表空间。
The only restriction when running an online backup in DB2 is that you cannot drop a table space while that table space is actively being backed up.
要减少这种想当然的想法并不难,只要删除特定于平台的约束并将它们变成可替换的,例如通过属性文件进行设置。
Reducing assumptions is as easy as removing platform-specific constraints and making them replaceable, such as through property files.
如果Cust - a有一个完整性约束来指明它必须拥有一个销售人员,则Cust - a必须先更新到新的Sales - B,然后才能删除Sales - a。
If Cust-A has an integrity constraint instructing that it must have a sales person, then Cust-A must first be updated to the new Sales-B before Sales-A is deleted.
添加或删除惟一、独特或外键约束。
Adding or dropping unique, distinct, or foreign key constraints.
同样,在执行装入操作期间,QApply程序也不删除别名上的参照完整性约束,并在这之后恢复它们。
Also, the Q Apply program does not drop referential integrity constraints on nicknames during the loading process and then restore them.
在这里,定义在昵称canada . items和us a . items上的检查约束将允许重写阶段删除其中一个UNION ALL分支。
In this case, the check constraints defined on nicknames canada.items and usa.items will allow the rewrite phase to eliminate one of the UNION all branches.
重写阶段将使用四个昵称上定义的引用约束和检查约束来删除连接操作和一个UNION分支。
The rewrite phase will use the referential and check constraints defined on the four nicknames to eliminate the join operations and one of the UNION branches.
因此,如果你删除了红色视图,蓝色视图同样可以拥有它的三个约束。
So, if you remove the red view, the blue view is left with three constraints holding it in place.
DELETE employees WHEREemployeeid=@employeeid请注意,如果由于特定于数据库的约束而无法删除记录,删除操作将失败。
Note that the delete operation fails if the record can't be deleted due to database-specific constraints.
利用检查约束和引用约束删除无效连接。
Removing unproductive joins with informational check and referential constraints.
从视图层次里删除一个视图就同时删除了该视图引用的所有约束。
Removing a view from the view hierarchy also removes all the constraints that reference that view.
删除这些约束中的任何一个,该布局就变成了不清晰的布局。
Remove any of these constraints, and the layout becomes ambiguous.
而第二种方法,当你删除红色视图之后,蓝色视图就只剩下一个约束。
In the second solution, removing the red view would leave the blue view with only a single constraint.
可以使用表设计器创建、编辑或删除表、列、键、索引、关系和约束。
You can use table Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints.
如果想要移除对强制引用完整性的要求,则可删除外键约束。
Delete a foreign key constraint when you want to remove the requirement to enforce referential integrity.
什么是最有效的方法做到这一点,试图一次删除每一个,让它导致SQL错误违反约束的错误?
What is the most efficient way of doing this short of trying to delete each one at a time and letting it cause SQL errors on the ones that violate constraints?
找到那些惟一/主键约束名,禁用这些约束然后再次删除表空间。
Find the constraint name for the unique/primary key, disable the constraint and drop the tablespace again.
从集合中删除选定的约束。
规则被删除后,在以前受规则约束的列中输入的新数据时将不受规则的约束。
After a rule is dropped, new data entered into the columns previously governed by the rule is entered without the constraints of the rule.
当希望移除对在约束表达式所包含的列或列组合中输入的值的唯一性要求时,可删除唯一约束。
Delete a unique constraint when you want to remove the requirement for uniqueness for values entered in the column or combination of columns included in the constraint expression.
从表格中删除线圈,约束与脊髓,使其形成一个环,并连接两端的插座,可以容纳一个微型手电筒灯泡的终端。
Remove the coil from the form, bind it with cord so that it forms a ring, and connect the ends to the terminals of a miniature socket that accommodates a flashlight bulb.
最后增加一些边满足跳数约束,再通过边置换和边删除来降低费用得到一个较优的扩充图。
Then the cost is reduced by iteratively exchanging edges. Finally some edges are added to meet the requirement …
最后增加一些边满足跳数约束,再通过边置换和边删除来降低费用得到一个较优的扩充图。
Then the cost is reduced by iteratively exchanging edges. Finally some edges are added to meet the requirement …
应用推荐