Search code examples
drupaldrupal-7drupal-modulesdrupal-webform

Drupal 7- webform : how to reset the webform submission id (sid) to 0?

I am using webform and drupal7. during testing I had created many test submissions. Now I have cleared all the submissions and all my webform tables are empty. But if I create a new submission I still get the sid as 51 (ideally it should have been 1)

Can anyone let me know how I can reset the sid value to 1?

Solution

  • Got it :) I just had to do the following:

    ALTER TABLE webform_submissions AUTO_INCREMENT = 1

    Thanks,