Gaps from other causes  Defining integrity constraints for tables

Chapter 8: Creating Databases and Tables

When table inserts reach IDENTITY column maximum value

The maximum number of rows you can insert into a table depends on the precision set for the IDENTITY column. If a table reaches that limit, you can either re-create the table with a larger precision or, if the table’s IDENTITY column is not used for referential integrity, use the bcp utility to remove the gaps. See “Reaching the IDENTITY column’s maximum value” for more information.





Copyright © 2005. Sybase Inc. All rights reserved. Defining integrity constraints for tables

View this book as PDF