sql server - How to delete a row with primary key id? -

i have sql table user. has 3 columns id(set primary , identity yes), name , password. when enter data table id became incremented. on delete query name , password deleted. need delete particular row including id. example:

id:1 name:abc password:123 id:2 name:wer password:234 id:3 name:lkj password:222 id:4 name:new password:999 

i need delete third column ie, id:3 name:lkj password:222 . after deleting row, table should shown below.

id:1 name:abc password:123 id:2 name:wer password:234 id:3 name:new password:999 

from additional information have provided shows not understand identity data type. others, including myself, have said numbers not re-used.

you should avoid changing primary keys because row deleted.

it seem need row number, don't use key this. create view using row_number function, like

select row_number() on (order id) row_number, name, password, ... [your_table]