新增、移除及管理主索引键和外部索引键。
如果该主索引键已存在,就会掷回这个例外状况。
在方格的下方,选择组成资料表主索引键的资料行。
In the grid beneath, choose the columns contributing to the table's primary key.
您想要能够读取资料列内的所有资料行,包括了主索引键。
You want to be able to read all the columns in the row, including the primary key.
您也可以从更新指令码置放主索引键、索引和唯一的条件约束。
You can also drop primary keys, indexes, and unique constraints from the update script.
如有需要,在[联结]对话方块中变更主索引键之间的比较运算子。
In the Join dialog box change the comparison operator between the primary keys as required.
如果该资料行位于资料表的主索引键,资料列选择器将显示索引键符号。
The row selector displays a key symbol if the column is in the table's primary key.
例如,含有名称之资料表的主索引键可能由第一个和最后一个名称组成。
For example, a primary key for a table containing names might be made up of both the first and last names as well.
选择的外部索引键资料行,必须与对应的主索引键资料行具有相同的资料型别。
The columns you choose for the foreign key must have the same data type of the primary columns they correspond to.
确定您未尝试将值指定至主索引键栏位,而此栏位中的主索引键已存在于资料表中。
Make sure you are not trying to assign a value to a primary key field where the primary key already exists in the data table.
寻找要更新或删除的资料列时,会使用到主索引键,除此之外不会进行任何其他的资料比较动作。
The primary key is used for locating the data row that will be updated or deleted, but no other comparison of the data is performed.
如果您在设计阶段就已知道主索引键资讯,建议您明确地指定主索引键资料行,以达到最佳效能。
If you know the primary key information at design time, we recommend that you explicitly specify the primary key column or columns in order to achieve optimal performance.
如果您在设计阶段就已知道主索引键资讯,建议您明确地指定主索引键资料行,以达到最佳效能。
If you know the primary key information at design time, we recommend that you explicitly specify the primary key column or columns in order to achieve optimal performance.
应用推荐