Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 18 Sep 2002 @ 13:50:33 GMT

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

Subj:   Re: Which tables are multiset?
From:   Richard Perry

Have you tried

Select * from dbc.tvm where requesttext like '%multiset%'

I cannot guarantee that this will give you all occurrences of multiset tables, but I understand it to contain the actual DDL entered at the time the table was created, so if 'MULTISET' was specified at the time of create, the requesttext will contain this string.

Hope this helps,


  <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