Diane,
You could, from the Enterprise Manager, generate scripts that will recreate your tables, so you could start fresh and relations would be kept. On the other hand, you might want to do a little calculation on "do I really need to start back at 1?"
Autonumbers from SQL Server are Integer fields and can reach 2,147,483,647. Now, assuming a single record is entered every second, 8 hours a day, 5 days a week, 52 weeks a year, your program will work for:
(2,147,483,647 / 60 sec per minute) = 35,791,394 minutes
(35,791,394 / 60 min per hour) = 596,523 hours
(596,523 / 8 hours per day) = 74,565 days
(74,565 / 5 days a week) = 14,913 weeks
(14,913 / 52 weeks a year) = 287 years...
Now, assuming you are entering data 24/7, you
only have 68 years... To find out how much time you have left, just substract whatever number you are up to now from 2,147,483,647.
>Hi all,
>
> I am working with VFP 6.0 and using automatic key field increment from SQL server for all the views I have. During the time of working with them, the key fields have been increasing and they are big numbers now. Is there any way that I can make them start over at 1 or less than the numbers I have righ now?
> I know that if I delete the tables on SQL server then create them again I can solve this problem. But I have many relationships between the tables and I don't want to mess up what I have been working on.
Sylvain Demers