On 11/1/22 03:31, jian he wrote:
>
>
> On Tue, Nov 1, 2022 at 2:33 PM 黄宁 <huangning0722(at)gmail(dot)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
>
>