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;
Comments
0 comments
Please sign in to leave a comment.