title: How to set Primary key to 1 after delete table data?
body: <p>I have a SQL Table named logindetails, it has 3 columns UserID ( set as primary and Is Identity as Yes), UserName and Password. I have inserted values to the table. But after the query "delete from logindetails" all data from the table except the UserID is deleted. Whenever I enter new data the ID will not be 1 and it is one greater than the last inserted ID. I need to automatically set it to 1.</p>