Archives of the TeradataForum
Message Posted: Wed, 18 Sep 2002 @ 13:50:33 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|