Controlling the ETL work in this manner can be useful for guaranteeing the proper sequence for loading data warehouse tables that contain primary or foreign key dependencies.
以这种方式控制ETL工作，对于保证按适当次序装载包含主键或外键依赖的数据仓库表十分有用。
For the sake of simplicity, consider VARCHAR as the default type for every column that is not a primary or a foreign key.
为了简单起见，考虑把VARCHAR作为除主键和外键外的所有列的默认类型。
This will not affect the referential integrity or primary-foreign key relationships between the tables in the membership database.
这不会影响到成员数据库中表格之间的主-外键关系。
You don't need to worry about messing around with the primary key or foreign key.
您无需担心处理主键或外键的麻烦。
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。
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。
应用推荐