Is it good to delete data from database?

Question

Yes, you should delete data from your database, but it's often not simple to tell what and when. "There's no way to cleanly determine what data is actually in use" - I would disagree. An "IsDeleted" bit field on each table is a pretty clean way to identify a record as no longer relevant.

Should you delete user data?

Keeping your users data and adding more and more users data will eventually pile up and create a large database to manage. So, if you really don't need the data then delete it. If you still want to keep it then keep it in the archived database so that it won't get loaded for every time you load the live database.

Why is deleting data important?

It's important to properly delete any personal information before you sell or dispose of your hardware, so that it cannot be accessed by anybody else either by mistake or for malicious purposes. Also, if you have a device that is faulty think about what personal data is stored on it before you dispose it.

What will happen if I delete data?

In other words, clearing data is equivalent to resetting an app. Think of clearing data as the combined process of uninstalling and re-installing the app, except for downloading the app again. Since clearing data removes the app cache, some apps such as the Gallery app will take some time to load.

When we delete a database what is deleted?

Dropping a database deletes the database from an instance of SQL Server and deletes the physical disk files used by the database. If the database or any one of its files is offline when it is dropped, the disk files are not deleted. These files can be deleted manually by using Windows Explorer.

Expert · Answer