In this activity, you add documentation to every element in the model, including every column, every table, every constraint, and every trigger.
在这种情况中,你把文档添加到模型的每一个元素中,包括每个列,每个表,每个约束和每个触发器。
The primary reason for using an ri constraint is to ensure that data integrity is maintained whenever one table references another.
使用一个RI约束的主要原因是,确保当一个表引用另一个表时数据完整性得到维护。
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之间那样。
For table, use the CHECK constraint to ensure integrity.
对于表,可以使用CHECK约束来确保完整性。
The CHECK constraint is perfect for this, as the following table definition shows.
CHECK约束非常适合执行此项操作,如以下所示表定义。
This clause is not allowed if the column is specified in the primary key, or in a unique constraint of the table (SQLSTATE 42831).
如果表的主键或惟一性约束中指定了这个列,那么不允许使用这个子句(SQLSTATE 42831)。
In that case, the primary table should be populated first to maintain the referential constraint.
在这种情况下,应该首先填充主表,以保持引用约束。
A constraint limits either a column or a table in some manner.
约束通过某种方式对列或表进行限制。
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值。
The latter is actually a primary key lookup against the parent table and constitutes the foreign key constraint verification.
索引扫描实际上是对父表进行主键查找,并完成外键约束验证。
The Constraint Elicitation TAB, shown in Figure 2, displays a view in which the analysis results (a listing of the anti-patterns detected) are presented in a table.
ConstraintElicitation选项卡,如图2所示,显示了在表格中展示分析结果(一列检测到的反模式)的视图。
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。
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 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值对于指定模式是有效的。
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
In table 6, the INSERT into the Orders table fails due to a foreign key constraint violation on custno.
在表6中,对orders表执行insert语句失败,因为custno违背了外键约束。
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触发器,然后执行约束检查。
The target table stock is altered and a constraint is added to the unit_price.
对表stock进行修改,向unit _ price增加了一个约束。
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.
检查约束(checkconstraint)是一类可以在创建表时作用到表列的约束。
In this syntax example, you must either define a new column or define a new table-level constraint.
在这个语法示例中,必须定义一个新列或者定义一个表级约束。
In DB2 V8 FP9, the registry variable setting DB2_STATVIEW is needed, and there is a constraint that only 2 table references can be in the statistical view.
在DB 2V 8 FP9中,需要设置注册表变量db2_statview,并且统计视图中只能有2个表引用。
You cannot define a foreign key constraint in a CREATE TABLE statement that contains an AS subquery clause.
你不能在CREATETABLE语句中包含AS子查询子句定义一个外键约束。
Creating a table with check constraint on an XML column.
创建一个xml列包含检查限制的表。
Instead, you must create the table without the constraint and then add it later with an ALTER table statement.
相反,你必须创建一个没有约束的表,然后添加alterTABLE语句。
The referenced unique or primary key constraint on the parent table or view must already be defined.
引用唯一或主键约束,必须是父表中已经定义的。
Removes the selected constraint from the table.
从表中移除选定的约束。
Indicates whether to enforce the constraint when a replication agent adds or updates data in this table.
指示复制代理将数据添加到此表中或更新此表中的数据时是否强制约束。
The unique constraint is created in the database when you save the table.
当保存表时,将在数据库中创建该唯一约束。
A Foreign key constraint allows you to define referential integrity between a parent and child table.
外键约束允许您定义父表和子表之间的引用完整性。
Select the column to which the constraint applies in Server Explorer, Database Diagram Designer, or Table Designer.
在服务器资源管理器、数据库关系图设计器或表设计器中选择应用该约束的列。
应用推荐