Archives of the TeradataForum

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

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

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,

Richard.

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