Can we change any system setting to create tables as MULTISET by Default

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Teradata Employee

Can we change any system setting to create tables as MULTISET by Default

Hi,

 

By default tables are created as SET. Is there any option to change this setting to MULTISET as default ?

 

May be in DBS Control or anywhere else ?

2 REPLIES 2
Ambassador

Re: Can we change any system setting to create tables as MULTISET by Default

As fa as I know the only way to get a MULTISET default is to switch Session Mode to ANSI.

But then lots of queries will not work/return a "wrong" result due to case sensivity issues.

Teradata Employee

Re: Can we change any system setting to create tables as MULTISET by Default

Hi dnoeth,

 

So, i guess this is related to the session mode rather than any general DBS Control setting.

 

Tags (1)