Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 05 Oct 2010 @ 15:06:02 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023