Optional parameter used with the Counter or Identity data types. Available in SQL DDL only when utilizing the Microsoft� OLE DB Provider for Jet. Can also be referred to as the starting value. The seed is the first of the two optional parameters to the Counter or Identity data types.
The following SQL statement is an example with the parameters:
CREATE TABLE Customers (CustId IDENTITY (100, 10) CONSTRAINT pkCustomers PRIMARY KEY, CFrstNm VARCHAR(10), CLstNm VARCHAR(15));
The column CustId in the first row will have a value of 100. The second row will have a value of 110.
When the optional parameters are utilized and do not contain values of (1,1), Jet will not reset the seed to the maximum value in the table. This behavior is different than in previous versions of Jet. If the optional parameters are not passed or a value of (1,1) is not used, when the database is compacted the seed will be reset to the maximum value of the Counter or Identity column in the table.
See Also