Creating a foreign key constraint with index disabled.
创建一个索引禁用的外键约束。
A foreign key user_id needs to be added to the SUBSCRIPTIONS table.
需要将一个外键user _ id添加到subscriptions表中。
A foreign key subscription_id needs to be added to the SUBJECTS table.
需要将一个外键subscription _ id添加到subjects表中。
Similarly if two tables are connected via a foreign key, they are connected.
与此类似,如果两张表通过一个外键连接起来,我们也称其为连接的。
You don't need to worry about messing around with the primary key or foreign key.
您无需担心处理主键或外键的麻烦。
Data type of primary key columns, foreign key columns, and columns used on indexes.
主键列、外键列和索引上使用的列的数据类型。
Run rake db: migrate to create the SUBJECTS table and add the subject_id foreign key.
运行rakedb:migrate,以创建subjects表并添加subject _ id外键。
It works at a basic level with MySQL, but it won't pick up foreign key relationships.
它基本上能用于MySQL,但不能提取外键关系。
Each one-to-many association is buried as a foreign key in the table of the many class.
每个一对多的关联在表中多个类中充当外键。
One-to-one relationships and one-to-many relationships are implemented using a foreign key.
一对一关系和一对多关系使用一个外键来实现。
Minimize the triggers, CHECK and foreign key constraints, and generated columns for the table.
尽量减少表上的触发器、检查和外键约束以及生成的列。
In the case of a one-to-one relation, your transformation creates a foreign key in each table.
在一对一关联的情况下,你的转换在所有表中都建立了一个外键。
Run rake db:migrate to create the SUBSCRIPTIONS table and add foreign key columns to SUBJECTS.
运行rakedb:migrate以创建SUBSCRIPTIONS表并将外键列添加到SUBJECTS 中。
For example, the foreign key to the date table is not repeated for every keyword of a document.
例如,日期表的外键对于一个文档的每个关键词不会重复。
Therefore, you need to map the foreign key attribute in Employee to the Department's primary key.
因此您需要将Employee的外部关键字属性,与Department的主关键字映射上。
The foreign key index will be disabled, and the sysobjstate catalog table will reflect that state.
外键索引将被禁用,sysobjstate目录表格也会反映该状态。
For foreign key creation, another table with a primary key with a compatible data type is required.
对于创建外键,则需要另外一个具有主键的表,且该主键具有兼容的数据类型。
During the foreign key enforcement, the server USES the sequential scan, instead of foreign key index.
在外键加强过程中,服务器使用顺序扫描,而不是外键索引。
The foreign key has not only an identifier to identify a record, but also a type to identify the table.
外键不仅具有标识记录的标识符,而且还具有标识表的一个类型。
New syntax for disabling an index for foreign key constraint was added to use with the ALTER statement.
用于为外键约束禁用索引的新语句被使用alter语句添加来使用。
Step 3: Replace the primary and foreign key values in rawdata.xml with appropriately abstracted tokens.
第三步:用合适的分离标记替换rawdata . xml中的主键以及外键值。
The belongs_to expresses the one-to-one foreign key relationship between the DOCUMENTS and USERS table.
belongs_to表达了DOCUMENTS与USERS表之间一对一的外键关系。
You can also establish a foreign key in a secondary table to link with a primary key in a primary table.
您还可以在次表中建立外键,以链接主表中的主键。
In the following example, an SQL statement captures foreign key information and generates DROP statements.
在下面的示例中,一个sql语句将捕捉外键信息并生成drop语句。
Indexes are defined on all primary and foreign key columns to support efficient joins between the 12 tables.
全部主键和外键均定义了索引,来支持12个表之间有效的结合。
An index pushdown USES the pushed-down keys to perform index lookups on a foreign key index of the fact table.
索引下推使用下推键执行事实表外键索引的查询。
A dimension table needs a generalized key as the primary key data; this becomes the foreign key in the fact table.
维度表需要作为主键数据的通用键;这将作为事实表的外键。
After the foreign key constraint with index disabled is dropped and recreated, the reversion completes successfully.
终止和重新创建索引禁用的外键之后,降级就成功完成了。
Figure 4 depicts the referential integrity (foreign key relationship) shown by a UML association between the tables.
图4描述了由一个表之间的UML关联所表示的引用完整性(外键关系)。
Ensure dependent tables in a referential integrity (ri) relationship have indexes that exactly match the foreign key.
确保参照完整性(referential integrity,ri)关系中的依赖表拥有与外键匹配的索引。
应用推荐