I have a few SQL tables that use an auto incrementing integer key field, ie it has 'is identify' set to yes
The tables have been used for testing while the application was developed.
I plan to delete all data from these tables when the application goes live. Is there a way to start SQL counting from 1 again without deleting and re-creating thr tables?
Check out Books on line for DBCC CHECKIDENT.
|||Excellent -thanks for that - searched using those terms and found what I needed.
Regards
Clive
No comments:
Post a Comment