![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Sat, 22 Dec 2007 @ 12:32:25 GMT
Subj: | | Re: Finding the set/multiset property of a table in the data dictionary |
|
From: | | Dieter Noeth |
Dieter Capek wrote:
| Perhaps tvm.checkopt was a valid multiset table indicator in 2000 (when the mentioned post was written). A week ago I did check this and
found multiset tables having both Y and N values on a TD Rel 5.0 system. My impression is that due to the lot of functionality added tvm.checkopt
is not a valid indicator for the multiset property any longer. | |
Tvm.checkopt just indicates if there will be duplicate row checks. A MULTISET table with a UNIQUE index simply doesn't require those
checks.
If you add a unique index to a multiset table, checkopt will change to 'N' and if you drop the USI or alter the UPI to NUPI, it will be change
back to 'Y'.
Btw, Merry Xmas :-)
Dieter
| |