Check constraint and view dependency on XML schema.
依赖XML模式的检查限制和视图。
Listing 5. Create check constraint on an XML column.
清单5.在xml列上创建检查限制。
Creating a table with check constraint on an XML column.
创建一个xml列包含检查限制的表。
MTK maps the ENUM data type to VARCHAR(255) with check constraint.
MTK 将ENUM数据类型映射到带检查约束的VARCHAR(255)。
The above example creates a check constraint on the column INFO which is of type XML.
以上例子在类型为XML的info列上创建了一个检查限制。
The example in Listing 5 shows how a single schema can be specified in a check constraint.
清单5中的例子显示了如何在检查限制中指定一个模式。
When you try to merge at line 21, you get the result 0 rows merged because the check constraint is violated.
当想在第21行进行合并时，会得到结果0rowsmerged因为检查约束发生了冲突。
The check constraint created above always checks that the document is validated according to the customer schema.
上面创建的检查约束总是会检查是否根据customer模式对文档进行了验证。
There is also a SQL editor control that contains intellisense capabilities to edit the check constraint expression.
还存在一个包含智能能力的SQL编辑器控件，用于编辑检查约束表达式。
The SQL editor control that contains intellisense capabilities is provided to edit the check constraint expression.
提供了包含智能感知功能的SQL编辑器控件来编辑检查约束表示。
If the data that is generated does not satisfy a check constraint on a column, the plan fails when you run it.
如果所产生的资料未满足资料行上的检查条件约束，当您执行计划时会失败。
A check constraint specifies the data values or formats that are acceptable in one or more columns in a table.
检查条件约束可指定在资料表中为一或多个资料行所接受的资料值或格式。
Syscat.checks Contains a row for each table check constraint db2 select constname, tabname, text from syscat.checks.
checks为每个表检查约束保持一个行db2select constname,tabname,textfrom syscat . checks。
The example in Listing 6 shows how multiple schemas can be listed while creating one particular check constraint.
清单6中的例子显示了如何在创建一个特定的检查限制时列出多个模式。
A check constraint is a type of constraint which can be put on a table column at the time of the creation of the table.
检查约束(check constraint)是一类可以在创建表时作用到表列的约束。
Note that the check constraint evaluates whether the XML document is validated or not. It does not perform the actual validation.
注意，检查限制计算是否验证了XML文档，它并不执行实际的验证。
This category of overhead includes CHECK constraint verification and foreign key constraint (referential integrity (ri)) verification.
这一类的开销包括检查约束验证和外键约束(参照完整性(RI))验证。
The before trigger and check constraint on a table XML value always ensures that the XML values are valid as per the specified schema.
对一个表XML值应用before trigger和检查约束，往往可以确保 XML值对于指定模式是有效的。
However, you can define the view using the WITH check OPTIONclause, which is equivalent to specifying a check constraint for the view.
但是你可以使用WITHcheckOPTION从句定义一个视图。这等同与你为视图指定check约束。
In this case, the DBA can put a check constraint on the XML column and ensure that the application USES one of the pre-registered schemas for validation.
对于这种情况，DBA可以在xml列上放置检查(check)限制，并确保应用程序使用预注册的模式之一执行验证。
For example, you might want to create a custom data generator if your database contains a column that has a check constraint that references another column.
例如，如果您的资料库有一个资料行具有参考另一个资料行的检查条件约束，您可能会想要建立自订资料产生器。
SYSCAT.COLCHECKS Contains a row for each column that is referenced by a table check constraint db2 select constname, tabname, colname, usage from syscat.colchecks
COLCHECKS为表检查约束所引用的每个列保持一个行db2select constname,tabname,colname,usage from syscat.colchecks
If an XML validation check constraint exists on the XML column of the table, the user may need to validate the new XML value before the update either manually or by creating a trigger.
如果在表的xml列上存在XML验证检查约束，在手动更新或者通过触发器更新之前，用户可能需要验证新的xml值。
Validate data: statement hooks let you validate parameter data before statement execution, providing the opportunity to do constraint check and data validation at the application level.
验证数据：通过语句钩子可以在执行语句之前验证参数数据，从而为应用程序级的约束检查和数据验证提供机会。
Multiple constraint technologies typically are required to comprehensively declare the constraints, and to check information at run-time before it is dispatched to the actual service logic.
为了完整地声明约束，并且在将其指派给实际的服务逻辑之前检查信息，通常需要多种约束技术。
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。
Now, follow these steps to add a new constraint to check for the existence of a masking method if a column is set as privacy data
现在，添加一个新约束，以便在将一个列设为privacydata时检查是否存在一个masking方法。
In Oracle 10g, if there is a BEFORE INSERT TRIGGER and a NOT NULL constraint on a table, then the BEFORE TRIGGER is executed first, and then the constraint check is performed.
在Oracle10g中，如果表上同时存在BEFORE INSERT触发器和NOT NULL约束，那么先执行BEFORE触发器，然后执行约束检查。
This may put a check on global warming by removing what would otherwise be a long-term constraint on the forest's ability to suck up carbon dioxide as it grows.
磷可能阻止了全球变暖，它使本来长期得不到生长的森林生长，使本来受限制的树木吸收二氧化碳的能力通过生长得到了释放。
Specifying this constraint through annotations means I no longer need to litter my code with repetitive conditionals that check for null and throw an exception on finding it.
通过标注指定这个约束条件意味着我的代码不再会被重复的条件弄得乱七八糟，这些条件检查null 值，并且一旦找到该值就会抛出异常。
应用推荐