Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search
Gaps due to insertions, deletions, identity grab size, and rollbacks [Table of Contents] Defining integrity constraints for tables

Transact-SQL User's Guide

[-] Chapter 7 Creating Databases and Tables
[-] Managing identity gaps in tables
[-] If table inserts reach the IDENTITY column's maximum value

If table inserts reach the IDENTITY column's 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.

Gaps due to insertions, deletions, identity grab size, and rollbacks [Table of Contents] Defining integrity constraints for tables