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


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.


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: 15 Jun 2023