Reset pimary key to 1

Hi Forum, I have a .mdf that I have used to test SQL data app. I want to reuse the .mdf; delete all added data and reset Customer_ID primary colomn back to 1. All good info appreciated thanks Paul

Hello there,

Try execute the statement TRUNCATE TABLE <table name>.

cheers,

Eric