I have a huge table, I am trying to drop some partitions from this table, however, in this application, tables are designed in such a way that foreign keys are created with on delete cascade enable
So I am nervous to drop or truncate some partitions from this table - what would be the negative impact, what other data i am going to drop / truncate in this process ?
So how can I find out all the tables in this database (all schemas in the current db) - that have foreign keys to this table (call it Table_A) - that I am planning to clear some data ?