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中的例子显示了如何在检查限制中指定一个模式。
You cannot specify a check constraint for a view.
你不能为一个视图指定check约束。
The check constraint created above always checks that the document is validated according to the customer schema.
上面创建的检查约束总是会检查是否根据customer模式对文档进行了验证。
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)是一类可以在创建表时作用到表列的约束。
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值对于指定模式是有效的。
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)限制，并确保应用程序使用预注册的模式之一执行验证。
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值。
Check constraint and view dependency on XML schema.
依赖XML模式的检查限制和视图。
For table, use the CHECK constraint to ensure integrity.
对于表，可以使用CHECK约束来确保完整性。
This category of overhead includes CHECK constraint verification and foreign key constraint (referential integrity (ri)) verification.
这一类的开销包括检查约束验证和外键约束(参照完整性(RI))验证。
This category of overhead includes CHECK constraint verification and foreign key constraint (referential integrity (ri)) verification.
这一类的开销包括检查约束验证和外键约束(参照完整性(RI))验证。
应用推荐