Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 20 Jan 2002 @ 12:18:52 GMT


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


Subj:   Re: Defaults for Create Table
 
From:   David Wellman

Craig,

I don't think there's an option at the database level. The SET or MULTISET option is really based on the session that issues the create table statement. On that side you can set the default to be either ANSI or Teradata.

If the session which issues the create table is running in ANSI mode, then the default is to create a multiset table, whereas if the session is running in Teradata mode then the default is to create a set table. Note that these are only defaults and can be over-ridden on the create table statement.

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)



     
  <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: 27 Dec 2016