 |
 |
Archives of the TeradataForum
Message Posted: Mon, 17 Oct 2005 @ 13:43:18 GMT
| Subj: | | Re: Bugs with identity column |
| |
| From: | | Mohommod.Khan |
One additional comment on Identity column that you may want to keep in mind that, if you have a Join Index, and you want this column to
participate on it, it will not work. Also you can not use 'CREATE TABLE DEST AS SOURCE W/O DATA if there is an Identity column (probably it makes
sense, since it is system generated....) . Although I will not call it a bug but rather it is a limitation. What I did, is to create a column
and used CSUM to generate it and make it work/look like an identity column rather System generated.
Hope this helps.
Mohommod Khan
| |
