https://www.webmaster-forums.net/crss/node/1013542 en https://www.webmaster-forums.net/web-database-development/defining-int-identity-field#comment-1078494 <p>Gil,</p> <p>SQL 6.5 should support the ALTER TABLE functions. Try this:</p> <p>Use Database_Name<br /> ALTER TABLE Table_Name<br /> ADD Identity_Column_Name integer<br /> identity(1,1)</p> <p>In the identity part the numbers in brackets represent what number to start with, and the increment. So if you wanted to start at 100 and go up by 10 every new record you would have identity(100,10)</p> <p>As for putting you own values into an identity field, this is not going to happen. The only thing I can think of is to set the column up as a regular column first, add you numbers to it, then set it up as an identity field.</p> Thu, 22 Feb 2001 14:20:44 +0000 Peter J. Boettcher comment 1078494 at https://www.webmaster-forums.net