Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 21 Mar 2003 @ 17:28:16 GMT

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

Subj:   Re: Fastload and default values
From:   Azzaretti, Sergio

The difference is that if you have a nullable column with a default value, you may insert NULL value. The default value is used, if you don't mention any value.


ct tab(col1 int default value 0);

ins tab(null); -> put NULL in table

ins tab(); -> put 0 in table


Sergio Azzaretti

  <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: 28 Jun 2020