 |
 |
Archives of the TeradataForum
Message Posted: Tue, 05 Oct 2010 @ 15:06:02 GMT
| Subj: | | Re: Setting the default table creation mode to |
| |
| From: | | Dieter Noeth |
Selim GUBUK wrote:
| | I would like to be able to create MULTISET tables without having to specify the MULTISET keyword. | |
| | Is there an option to set the default table creation mode to MULTISET? | |
The only way i know of is to switch your session mode to ANSI.
BUT there are other differences, too. E.g. a character column in ANSI mode is created by default as "CaseSpecific" whereas in Teradata mode
it's "Not CaseSpecific".
Dieter
| |
