All Forums Database
keets_teradata 3 posts Joined 02/13
27 Mar 2014
SET table to Multiset Table

Can existing table with Data, defined as SET be changed to MULTISET Table without dropping and re-creating the table?

Raja_KT 1246 posts Joined 07/09
28 Mar 2014

I think you mean to say thus(example):
Create multiset table dbname.multiset_table_name as dbname.set_tbl with data;
It works. Why dont you try??

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

oshun 43 posts Joined 07/10
31 Mar 2014

You can create a copy of a table and change the table level attribute from SET to MULTISET. This can be done with the statement for cloning tables CREATE TABLE AS...
You can't change just the attribute from SET to MULTISET. 
 
 

visit my private blog at http://www.dwhpro.com

Adeel Chaudhry 773 posts Joined 04/08
09 Apr 2014

Simple answer would be .... No.  :)

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.