在这种情况中,你把文档添加到模型的每一个元素中,包括每个列,每个表,每个约束和每个触发器。
In this activity, you add documentation to every element in the model, including every column, every table, every constraint, and every trigger.
这些关系通过创建表之间的约束关系来确定。
These relationships are identified through the creation of constraints between tables.
在数据库中定义约束使DB 2可以知道表之间的关系,并且在某些情况下允许DB 2根据这样的知识选择更好的访问计划。
Having the constraints defined in the database allows DB2 to know relationships between tables and in some cases allows it to select better access plans based on that knowledge.
对于表,可以使用CHECK约束来确保完整性。
CHECK约束非常适合执行此项操作,如以下所示表定义。
The CHECK constraint is perfect for this, as the following table definition shows.
这个表使用引用完整性约束确保数据的有效性。
This table USES referential integrity constraints to ensure data validity.
它们由逻辑数据模型转换而来,其中实体和关系转换为表、列、主键、外键以及约束。
They are transformations of logical data model where the entities and relationships are transformed into tables, columns, primary keys, foreign keys, and constraints.
因为开发人员通常会依赖数据库的约束,所以生成的表可能非常难以处理。
The resulting table may prove very difficult to work with, since developers typically rely on database constraints.
确定表设计所给出的约束。
目前的CTP 1仅支持表、索引和约束。
索引扫描实际上是对父表进行主键查找,并完成外键约束验证。
The latter is actually a primary key lookup against the parent table and constitutes the foreign key constraint verification.
这两个数据库内的表通过相同的XML模式约束。
The tables in the two databases are constrained using the same remote XML schema.
对于第二个策略(每个类层次结构一个表),您必须用检测约束定义您自己的完整性。
For our second strategy (one table per class hierarchy), you'll have to define your integrity using check constraints.
Update规则控制对由 RI约束链接的表执行的更新操作的处理方法。
The Update rule controls how update operations performed against tables linked by an RI constraint are processed.
不复制在模板表的列上定义的约束。
The constraints defined on the columns of the template table are not copied.
注意,使用MicrosoftAccess修改和添加条目时,遵守底层数据库表的约束。
Note that when modifying and adding entries using Microsoft Access, the constraints of your underlying database tables are adhered to.
SQLAzure的基础是关系数据库模型、提供了对约束、事务、临时表以及存储过程的完整支持。
SQL Azure is based on the relational database model, complete with constraints, transactions, temporary tables, and stored procedures.
还可以创建表、视图、用户、约束与索引。
It can also be used to create tables, views, users, constraints and indexes.
checks为每个表检查约束保持一个行db2select constname,tabname,textfrom syscat . checks。
Syscat.checks Contains a row for each table check constraint db2 select constname, tabname, text from syscat.checks.
Checkconstraints视图—允许添加表及其列的检查约束。
Check constraints view a "Allows adding check constraints for a table and its columns."
COLCHECKS为表检查约束所引用的每个列保持一个行db2select constname,tabname,colname,usagefrom syscat.colchecks
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
在表上创建约束(例如,RI、信息、惟一)。
Creating constraints on tables (for example, RI, informational, unique).
如果远程表在数据上有检查约束,那么可以使用信息检查约束将这些约束传递到联邦服务器。
If the remote tables have restrictions on the data such as check constraints, you can convey these restrictions to the federated server using informational check constraints.
我们建立一定的时间表、约束条件、检查点,和通信程序,但我们将细节留给第三方。
We establish certain timetables, constraints, checkpoints, and communication procedures; but we leave the details to the third party.
在这个语法示例中,必须定义一个新列或者定义一个表级约束。
In this syntax example, you must either define a new column or define a new table-level constraint.
如果您使用like语句创建cgtt表(像普通表一样创建CGTT),则该语句会执行成功,但CGTT不会继承原始表的约束。
If you create a CGTT table using the like clause (create CGTT like a regular table), the statement will be successful, but the CGTT will not inherit the constraints of the original table.
如果表的主键或惟一性约束中指定了这个列,那么不允许使用这个子句(SQLSTATE 42831)。
This clause is not allowed if the column is specified in the primary key, or in a unique constraint of the table (SQLSTATE 42831).
尽量减少表上的触发器、检查和外键约束以及生成的列。
Minimize the triggers, CHECK and foreign key constraints, and generated columns for the table.
“传统的”应用程序必须要维护存储这些数据项的表并实施完整性约束。
A 'traditional' application would need to maintain tables for each of these data items and enforce integrity rules.
“传统的”应用程序必须要维护存储这些数据项的表并实施完整性约束。
A 'traditional' application would need to maintain tables for each of these data items and enforce integrity rules.
应用推荐