Archives of the TeradataForum
Message Posted: Wed, 18 Sep 2002 @ 18:48:57 GMT
| Subj: | | Re: Which tables are multiset? |
| |
| From: | | MARK FERGUSON |
FYI..........
On the topic of multiset tables, multiset is not 'hereditary'. If you use the syntax 'CREATE TABLE tableY AS tableZ......' and tableZ is
a multiset table, tableY will not be multiset. You must specify that tableY be multiset as well.
ex: CREATE MULTISET TABLE tableY AS tableZ......
Mark K. Ferguson
LVM Team
Enterprise Data Warehouse
Federated Systems Group
| 
