Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 05 Oct 2010 @ 16:50:34 GMT


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


Subj:   Re: Setting the default table creation mode to
 
From:   John_Wight

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?  


It sounds like you want this to 'default' when you create tables.

Question: what is the reason for wanting to 'remove' this important table constraint as a 'default'? There are penalties for making everything MULTISET and if you don't take care of these, you can get yourself into 'deep trouble' like having duplicates rows, etc. Yes, it's a great 'option' but needs to be used appropriately. I've been @ customer sites that do this and we inevitably find tables that they don't know they have sup rows in it!!! AND that causes issues.

Guess my feedback is, be careful what you ask for!


JK



     
  <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