Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 19 Sep 2002 @ 12:47:30 GMT

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

Subj:   Re: Which tables are multiset?
From:   Geoffrey Rommel

John Hall wrote:

  I'm probably being anal,  


  but as it applies to a Table, the CHECKOPT flag really doesn't indicate whether a table is SET or MULTISET, but rather whether duplicate row checking will be skipped.  

I believe you're right, John. I found this description in the Data Dictionary Reference for V2R3 under DBC.Tables[X], column UnnamedTblCheckExist: "indicator for whether the table has an unnamed table-level check constraint". Clear as a bell, eh?

  <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