an identity column and populate it with a few rows: — Create a test table. CREATE TABLE TestIdentityGaps ( ID int IDENTITY PRIMARY KEY, Description varchar (20) ) GO — Insert some values.