On 11/1/22 03:31, jian he wrote:
On Tue, Nov 1, 2022 at 2:33 PM 黄宁 <huangning0...@gmail.com> wrote:
I now have two tables named A and B. Table B is calculated based
on the data of table A. I wonder if table B can be automatically
deleted when table A is deleted？
Your question seems not that specific.
You can use https://dbfiddle.uk/btGcOH30 to showcase your specific
problem/question.
you can use DROP TABLE CASCADE.
DROP TABLE manual:
https://www.postgresql.org/docs/current/sql-droptable.html
Only If B has a foreign key reference to A
--
I recommend David Deutsch's <<The Beginning of Infinity>>
Jian
