Archives of the TeradataForum
Message Posted: Tue, 05 Oct 2010 @ 16:50:34 GMT
| Subj: | | Re: Setting the default table creation mode to |
| |
| From: | | John_Wight |
Selim GUBUK wrote:
| | I would like to be able to create MULTISET tables without having to specify the MULTISET keyword. | |
| | Is there an option to set the default table creation mode to MULTISET? | |
It sounds like you want this to 'default' when you create tables.
Question: what is the reason for wanting to 'remove' this important table constraint as a 'default'? There are penalties for making everything
MULTISET and if you don't take care of these, you can get yourself into 'deep trouble' like having duplicates rows, etc. Yes, it's a great
'option' but needs to be used appropriately. I've been @ customer sites that do this and we inevitably find tables that they don't know they have
sup rows in it!!! AND that causes issues.
Guess my feedback is, be careful what you ask for!
JK
| 
