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之间那样。
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)。
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触发器,然后执行约束检查。
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.
指示复制代理将数据添加到此表中或更新此表中的数据时是否强制约束。
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.
在服务器资源管理器、数据库关系图设计器或表设计器中选择应用该约束的列。
Creates a constraint for the selected database table and provides a default name and other values for the constraint.
为选定的数据库表创建约束,并为该约束提供默认名称和其他值。
You can attach multiple unique constraints to a table, whereas you can attach only one primary key constraint to a table.
可将多个唯一约束附加到表,但是只能将一个主键约束附加到表。
The constraint is updated in the database when you save your table or diagram.
当保存表或关系图时,约束将在数据库中得到更新。
A primary key is a constraint that assures that each table contains no duplicate rows.
主键是确保每个表都不包含重复行的约束。
If there were no mechanism to allow temporary constraint suspension, an error would be raised every time you tried to load a record into the child table.
如果没有允许暂止暂时性条件约束的机制,则每次尝试将资料录载入到子资料表时,就会引发错误。
A check constraint specifies the data values or formats that are acceptable in one or more columns in a table.
检查条件约束可指定在资料表中为一或多个资料行所接受的资料值或格式。
应用推荐