I want to delete all the entires in the table before adding new ones and reset the PrimaryKey back to 1.

This is my Entity

```
@PrimaryKey(autoGenerate = true)
private int id;
private int weatherId;
private String highTemp;
private String lowTemp;

```

So i used

```
if(weatherEntries != null && weatherEntries.size() != 0){
        Log.d(TAG, "WeatherEntry List is not empty");
            mDb.clearAllTables();

            for(int i = 0; i < weatherEntries.size(); i++) {
                mDb.weatherDao().insertWeather(weatherEntries.get(i));
                Log.d(TAG, "Inserting Weather Data into the Database");
            }
        }

```

When the new entries are added their primary key doesn't start from 1.
So, I have tired to query

```
@Query("ALTER TABLE SequenceAction AUTO_INCREMENT = 0")
void clearPrimaryKey();

```

I get the error

> 
> "error: no variable alternative at input 'SequenceAction AUTO\_INCREMENT'"
> 
> 
> 

I tried to look google on how to solve this and even looked at the Android Documentation of Room as how to reset the primary key but haven't found anything.

Any Help would be highly appreciated.