If you are creating a table in a select into statement from a table that has a specific identity gap setting, the new table does not inherit the identity gap setting from the parent table. Instead, the new table uses the identity burning set factor setting. To give the new table a specific identity_gap setting, specify the identity gap in the select into statement. You can give the new table an identity gap that is the same as or different from the parent table.
For example, to create a new table (newtable) from the existing table (mytable) with an identity gap:
select IdNum into newtable with identity_gap = 20 from mytable
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
