SET table to Multiset Table

Database

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?

Tags (1)
3 REPLIES
Enthusiast

Re: SET table to Multiset Table

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??

Enthusiast

Re: SET table to Multiset Table

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. 

Roland Wenzlofsky
Teradata Employee

Re: SET table to Multiset Table

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