Hello. In my application, I must delete the table if all the rows within a column are specific value. An example can be found here:
https://www.db-fiddle.com/f/siZmmKWLjRDdpYX6deEPYF/0
Throughout my program, I am modifying "Status_s" column and changing the status from "IDLE" to done. When all the rows are "DONE" I need to drop the table.
Can someone help me understand how do I drop table with a condition. Thanks in advance
https://www.db-fiddle.com/f/siZmmKWLjRDdpYX6deEPYF/0
Throughout my program, I am modifying "Status_s" column and changing the status from "IDLE" to done. When all the rows are "DONE" I need to drop the table.
Can someone help me understand how do I drop table with a condition. Thanks in advance