|
|
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?
| |