Types of Tables in Teradata

1 SET
2 MULTI SET
3 GLOBAL TEMPORARY TABLES
4 TEMPORARY TABLES
5 VOLATILE TEMPORARY TABLES

SET表中如有UPI，则由UPI保证非重复记录

定义字段
ename CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC
select * from scott.emp where ename(CASESPECIFIC) = 'FAN'
select * from scott.emp_case where ename(not CASESPECIFIC) = 'FAN';
select * from scott.emp_case where upper(ename) = 'FAN';

CREATE GLOBAL TEMPORARY MULTISET TABLE scott.gt_deptsal
(deptno SMALLINT
,avgsal DEC(9,2)
,maxsal DEC(9,2)
,minsal DEC(9,2)
,sumsal DEC(9,2)
,empcnt SMALLINT)
PRIMARY INDEX (deptno)
ON COMMIT PRESERVE ROWS;

查数据字典：select * from dbc.tables where tablename = 'gt_deptsal'
物化表：insert into scott.gt_deptsal values (22,33,33,22,22,22)；
查询物化表：物化后DBC.TempTables 表会存在一条表记录，物化表drop后记录删除：
select * from DBC.TempTables;

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/fanxiaoliang83/archive/2009/07/30/4395457.aspx

Tweet