|
Archives of the TeradataForumMessage Posted: Thu, 18 Aug 2005 @ 08:07:25 GMT
Hi forum, I want to use IDCs in some tables. I use the sysntax like [...] TABLE_ID INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1 NO CYCLE) ,TABLE_ORDER INTEGER NOT NULL [...] I wonder about the cache for the generated numbers. I miss the option 'no cache'. I have the sometimes steps like: TABLE_ID 1 2 3 4 10001 10002 30001 ... Normally that's no problem, but in some scripts (for testing) I had the foreign-key numbers fixes in an insert statement. Is there any possibility to disable the caching of numbers? Thanks in advance, Dirk
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||