Re: Delete a table automatic?

Rob Sargent <robjsargent@xxxxxxxxx> · Tue, 1 Nov 2022 07:41:14 -0600



    On 11/1/22 03:31, jian he wrote:

    
          On Tue, Nov 1, 2022 at 2:33
            PM 黄宁 <huangning0722@xxxxxxxxx>
            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