Delete
method or with DELETE
SQL queries, read more in Data manipulation - delete. staradmin start cleaner
.staradmin start cleaner
launches the cleaning process by looking up all DROP TABLE
or ALTER TABLE
commands that were executed since the last time it ran. It will run until all those commands have been processed and then terminate. This will permanently delete the tables and columns.start cleaner
can't be recovered. Backup your data before deleting anything to have a safe point to revert to. UselessTable
that is not needed anymore:UselessTable
from the code and all the references to the class.ScErrColumnIsMapped (SCERR15014)
.DROP TABLE
without deleting all the references to the table in all the apps that are running, Starcounter will throw ScErrTableIsReferenced (SCERR15012)
. UselessTable
, execute staradmin start cleaner
, when it's finished, it will print: Done (nothing more to clean)
.UselessTable
back to the code, executing SELECT * FROM MyApp.UselessTable
will yield no results. The data has successfully been deleted.staradmin start cleaner
might produce transaction conflicts with running applications, thus, run the cleaning when the load is low to avoid performance drops.staradmin start cleaner
deletes the data and column that has been marked.IrrelevantFact
should be deleted from the Person
table:ScErrColumnIsMapped (SCERR15014)
.ALTER TABLE
command can't be executed while the table it alters is referenced in any running app - you have to stop the app before running ALTER TABLE
, you can do this by running staradmin stop app MyApp
.DROP COLUMN
or DROP TABLE
, you can't have the affected tables loaded. This means that the apps with references to those tables can't run unless the references to the tables are removed in the app.