这些关系通过创建表之间的约束关系来确定。
These relationships are identified through the creation of constraints between tables.
目前的CTP 1仅支持表、索引和约束。
还可以创建表、视图、用户、约束与索引。
It can also be used to create tables, views, users, constraints and indexes.
在这种情况中,你把文档添加到模型的每一个元素中,包括每个列,每个表,每个约束和每个触发器。
In this activity, you add documentation to every element in the model, including every column, every table, every constraint, and every trigger.
注意,使用MicrosoftAccess修改和添加条目时,遵守底层数据库表的约束。
Note that when modifying and adding entries using Microsoft Access, the constraints of your underlying database tables are adhered to.
确定表设计所给出的约束。
对于表,可以使用CHECK约束来确保完整性。
不复制在模板表的列上定义的约束。
The constraints defined on the columns of the template table are not copied.
Checkconstraints视图—允许添加表及其列的检查约束。
Check constraints view a "Allows adding check constraints for a table and its columns."
这两个数据库内的表通过相同的XML模式约束。
The tables in the two databases are constrained using the same remote XML schema.
这个表使用引用完整性约束确保数据的有效性。
This table USES referential integrity constraints to ensure data validity.
Update规则控制对由 RI约束链接的表执行的更新操作的处理方法。
The Update rule controls how update operations performed against tables linked by an RI constraint are processed.
它们由逻辑数据模型转换而来,其中实体和关系转换为表、列、主键、外键以及约束。
They are transformations of logical data model where the entities and relationships are transformed into tables, columns, primary keys, foreign keys, and constraints.
索引扫描实际上是对父表进行主键查找,并完成外键约束验证。
The latter is actually a primary key lookup against the parent table and constitutes the foreign key constraint verification.
SQLAzure的基础是关系数据库模型、提供了对约束、事务、临时表以及存储过程的完整支持。
SQL Azure is based on the relational database model, complete with constraints, transactions, temporary tables, and stored procedures.
如果在表的xml列上存在XML验证检查约束,在手动更新或者通过触发器更新之前,用户可能需要验证新的xml值。
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值应用before trigger和检查约束,往往可以确保 XML 值对于指定模式是有效的。
The before trigger and check constraint on a table XML value always ensures that the XML values are valid as per the specified schema.
在数据库中定义约束使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.
但是从我们数据模型的角度来看,我们没有一个惟一的表可以用来创建我们的外键约束,就像TB_RIGHT和TB_PERSON之间那样。
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.
例如,表可能依赖于用户定义的不同类型;检查约束依赖于函数;视图依赖于视图、别名和函数;等等。
For example, tables may depend on user-defined distinct types; check constraints depend on functions; views depend on views, aliases, and functions; and so on.
请按清单7所示的顺序将字段添加到这个块(这些约束不影响列在表中的顺序—只影响在视图中的顺序)。
Add the fields to this block in the order shown in Listing 7. (These constraints don't affect the order of the columns in the table - just the view.)
表items和SUPPLIERS分别在列item_id和suppl_id上定义了检查约束。
Both tables ITEMS and SUPPLIERS have check constraints defined on columns item_id and suppl_id respectively.
推荐:为带有参照完整性约束的别名使用“noload”选项,并在复制管理工具外部装入目标表。
Recommendation: Use the "no load" option for nicknames with referential integrity constraints and load the target table outside of the replication administration tools.
可以传输表、数据、存储过程、引用完整性约束、安全性和索引。请指定要传输的对象。
Transfer tables, data, stored procedures, referential integrity constraints, security, and indexes. Specify the object (s) to transfer.
唯一约束是表的主键,因此不能移除。
Can't remove unique constraint since it's the primary key of a table.
从表中移除选定的约束。
ActiveRecord在使用参考完整性约束的某些场合也会出现问题,因为某些类型的关联可能连接到多个数据库表。
ActiveRecord also has trouble in some cases with referential integrity constraints because some types of associations might connect to more than one database table.
因为开发人员通常会依赖数据库的约束,所以生成的表可能非常难以处理。
The resulting table may prove very difficult to work with, since developers typically rely on database constraints.
目标表不能有触发器与完整性约束。
The target table cannot have any triggers or referential integrity constraints defined on it.
我如何修改SQL表中的数据模式的约束?
How do I modify this SQL schema to constrain data in tables?
应用推荐