Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Removing Unused Columns from Participants Database
on any administrative page, add ?pdb-remove-orphan-columns to the URL, then hit return to execute it.
This will delete the columns that do not have a corresponding field definition from the main Participants Database table.
Always work with a backup for operations like this.
for example:

This comment has been minimized.

Copy link
Owner Author

@xnau xnau commented May 17, 2021

Probably unnecessary because there is no performance penalty for unused columns, however in the interest of good database housekeeping, you may want to do this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment