Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reset AUTO_INC
Message
From
08/11/2005 12:54:13
David Frankenbach
Austin, Texas, United States
 
 
To
07/11/2005 23:28:35
Aaron K. Y. Chu
Health & Care Co. Ltd.
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Reset AUTO_INC
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
MySQL
Miscellaneous
Thread ID:
01066297
Message ID:
01066514
Views:
27
Aaron,
dbcc CHECKIDENT ('TableName', RESEED, 1)
>Nearly all my tables are indexed by AUTO_INC, how could I reset to beginning like 1 or some other value, since some of records are added during testing period...
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform