Altering SET to MULTISET

Database
Enthusiast

Altering SET to MULTISET

Hi,

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

Tags (2)
3 REPLIES
Junior Contributor

Re: Altering SET to MULTISET

Short answer: No.

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

Dieter

Enthusiast

Re: Altering SET to MULTISET

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.

Re: Altering SET to MULTISET

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: