Can users delete the tables they created?

Yes. Users that belong to any team (Admins, Editors, Viewers) can delete the tables they created. Both admins and editors also have the permission to delete tables they did not create.

A user must first know what team he or she belongs to, to avoid encountering an error when deleting a table. After that, the user can opt to remove a table in Panoply through its UI or drop multiple tables by executing a DROP TABLE SQL statement in the Workbench or any SQL client tool that can connect to Panoply.

Users can also run the query provided below to know the tables they own/created. Just replace panoply_username with their own username.

SELECT schemaname, tablename, tableowner
FROM pg_tables
WHERE
  schemaname != 'pg_catalog'
 AND schemaname != 'information_schema'
 AND tableowner LIKE 'panoply_username'
ORDER BY tablename ASC;