Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 01 Aug 2002 @ 12:41:53 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Volatile table & VB
From:   Geoffrey Rommel

  The default to delete the rows is I believe an ANSI standard and not Teradata specific,  


"If TEMPORARY is specified and ON COMMIT is not specified, then ON COMMIT DELETE ROWS is implicit." (SQL Foundation, Vol. 2, ISO/IEC 9075-2:1999, sec. 11.3, rule 12, p. 407)

  but stupid (in my humble opinion).  

I agree!


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