Lets say i have have a table with 200 records and i deleted all of them now when i try to add another record to that table i want the id of the record to start from 1 instead of 201. i tried this code but doesn't work Lets say i have have a table with 200 records a