• In this activity, you add documentation to every element in the model, including every column, every table, every constraint, and every trigger.

    这种情况中,文档添加模型一个元素包括每个,每个,每个约束每个触发器

    youdao

  • The primary reason for using an ri constraint is to ensure that data integrity is maintained whenever one table references another.

    使用RI约束主要原因确保引用另一个表时数据完整性得到维护。

    youdao

  • 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_RIGHTTB_PERSON之间那样。

    youdao

  • For table, use the CHECK constraint to ensure integrity.

    对于可以使用CHECK约束确保完整性

    youdao

  • The CHECK constraint is perfect for this, as the following table definition shows.

    CHECK约束非常适合执行此项操作,以下所示定义

    youdao

  • 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)。

    youdao

  • In that case, the primary table should be populated first to maintain the referential constraint.

    这种情况下应该首先填充主表保持引用约束

    youdao

  • A constraint limits either a column or a table in some manner.

    约束通过某种方式进行限制

    youdao

  • 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

    youdao

  • The latter is actually a primary key lookup against the parent table and constitutes the foreign key constraint verification.

    索引扫描实际上进行查找完成约束验证

    youdao

  • 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所示显示表格展示分析结果(检测到反模式)的视图

    youdao

  • 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。

    youdao

  • 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。

    youdao

  • 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对于指定模式有效的。

    youdao

  • 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

    youdao

  • In table 6, the INSERT into the Orders table fails due to a foreign key constraint violation on custno.

    6中,orders表执行insert语句失败因为custno违背约束

    youdao

  • 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触发器,然后执行约束检查。

    youdao

  • The target table stock is altered and a constraint is added to the unit_price.

    stock进行修改unit _ price增加了一个约束

    youdao

  • 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)一类可以创建作用到表约束。

    youdao

  • In this syntax example, you must either define a new column or define a new table-level constraint.

    这个语法示例中,必须定义或者定义一个表级约束

    youdao

  • 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引用

    youdao

  • You cannot define a foreign key constraint in a CREATE TABLE statement that contains an AS subquery clause.

    不能CREATETABLE语句中包含AS子查询子句定义约束

    youdao

  • Creating a table with check constraint on an XML column.

    创建一个xml列包含检查限制

    youdao

  • Instead, you must create the table without the constraint and then add it later with an ALTER table statement.

    相反必须创建一个没有约束然后添加alterTABLE语句。

    youdao

  • The referenced unique or primary key constraint on the parent table or view must already be defined.

    引用唯一约束必须表中已经定义的。

    youdao

  • Removes the selected constraint from the table.

    中移除选定约束

    youdao

  • Indicates whether to enforce the constraint when a replication agent adds or updates data in this table.

    指示复制代理数据添加更新此表中的数据是否强制约束

    youdao

  • The unique constraint is created in the database when you save the table.

    保存表时,将数据库创建唯一约束

    youdao

  • A Foreign key constraint allows you to define referential integrity between a parent and child table.

    约束允许定义父表之间引用完整性

    youdao

  • Select the column to which the constraint applies in Server Explorer, Database Diagram Designer, or Table Designer.

    服务器资源管理器数据库关系图设计设计器中选择应用约束

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定