Parameters for controlling identity gaps  Example of using identity burning set factor

Chapter 8: Creating Databases and Tables

Comparison of identity burning set factor and identity_gap

The identity_gap parameter gives you control over the size of identity gaps for a particular table as illustrated in the following examples. In the examples, we have created a table named books to list all the books in our bookstore. We want each book to have a unique ID number, and we want Adaptive Server to automatically generate the ID numbers.





Copyright © 2005. Sybase Inc. All rights reserved. Example of using identity burning set factor

View this book as PDF