On Fri, Nov 15, 2024 at 12:46 PM Bharani SV-forum <esteembsv-fo...@yahoo.com> wrote:
> Need exact SQL query to find List of Detach Partitioned Tables (Yet to be > Dropped) > > The premise that a detached table is distinguishable from any other table that is not a partition is an interesting one that I wouldn't necessarily expect to be determinable. You could probably write a query listing tables that are candidates for attaching to an existing partitioned table and then filter out those that are actually attached. David J.