 |
 |
Archives of the TeradataForum
Message Posted: Thu, 19 Sep 2002 @ 12:47:30 GMT
| Subj: | | Re: Which tables are multiset? |
| |
| From: | | Geoffrey Rommel |
John Hall wrote:
Probably.
| | 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?
| |
