All Forums Database
ppad001 18 posts Joined 06/11
06 Dec 2011
Altering SET to MULTISET


Is there is a way to alter a set table to multiset apart from drop re-create table..?

dnoeth 4628 posts Joined 11/04
07 Dec 2011

Short answer: No.

But don't ask me why it's not possible.



Jim Chapman 449 posts Joined 09/04
07 Dec 2011

The correct answer to "why" in cases like this is often the business requirement was never presented ... or we just didn't think of it at the time.

binoarun 2 posts Joined 07/13
21 Jul 2013

Yes we can.. consider ur table is custome as a set table k... nw just write syntax 
create multiset table customer_1 as customer with data (or) with no data:

You must sign in to leave a comment.