Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reset @@identity
Message
From
21/06/2001 12:50:50
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00521874
Message ID:
00522012
Views:
17
>Hi!
>
>Just generate SQl Script for all your tables, delete them all, then re-create them again. Re-creating table from zero will reset the current identity value. If you have no daat in table, it is safe and easy (just right click on the table in Enterprise Manager and find the Generate SQL Script... or something like that).
>
>HTH.
>
>PS: is not it the question for SQl Server forum???

Vlad,

You're right, is a question for SQL Server forum. I'll subscribe there right now. I'm so sorry.

Thank you very much for the answer. Now I have two ways to do what I want. :)

Thanks again
Grigore Dolghin
Class Software.
Previous
Reply
Map
View

Click here to load this message in the networking platform