Actually dont delete add a column called delflag and active , If u want see the data that need to be listed out set active = 1 and delflag = 0 This may help u to keep the data as deleted stated if delflag = 1 and when ever u want to modify the data and keep in table u may update the row as active = 1 And Also use primary key and Identity(0,1) in UserId column of table creation it may varies according too sql flavours