Archives of the TeradataForum

Message Posted: Fri, 17 Dec 2004 @ 12:05:52 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

With the positive increment and a max value defined - when you have a "cycle" clause the id column will either re-start from the min value (if defined) else will start with the min value of the column data type.

- If the max value was not defined and with a cycle clause it would re-start after having reached the max value of the particular data type

- but again it would restart either from the min value(if specified) or the min value of the column data type.

Rules governing the "START WITH" is, that it should either be

- <= Max value (or <= max value of the particular column data type)

- >= Min value (or >= min value of the particular column data type)

And Identity column feature is said to be ANSI SQL-99 compliance.

Narayan

	<Prev	Next>		<<First	<Prev	Next>	Last>>