dws
DBC.TABLES
更新时间:2020/04/21 GMT+08:00
DSC会将dbc.tables迁移为对应的mig_td_ext.vw_td_dbc_tables。
示例:databasename迁移为mig_td_ext.vw_td_dbc_tables.schemaname。
输入
1 2 3 4 5 | sel databasename,tablename FROM dbc.tables
WHERE tablekind='T' and trim(databasename) = '<dbname>'
AND
( NOT(TRIM(tablename) LIKE ANY (<excludelist>))
);
|
输出
1 2 3 4 5 6 7 8 9 10 11 | SELECT
mig_td_ext.vw_td_dbc_tables.schemaname
, mig_td_ext.vw_td_dbc_tables.tablename
FROM
mig_td_ext.vw_td_dbc_tables
WHERE
mig_td_ext.vw_td_dbc_tables.tablekind = 'T'
AND TRIM(mig_td_ext.vw_td_dbc_tables.schemaname) = '<dbname>'
AND( NOT( TRIM(mig_td_ext.vw_td_dbc_tables.tablename) LIKE ANY ( ARRAY[ < excludelist > ] ) ) )
;
|
父主题: Teradata语法迁移
