Re: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped)

2024-11-15 Thread Adrian Klaver
On 11/15/24 11:46, Bharani SV-forum wrote:  Team Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped) The following is the query which i used, i am using and i found an bug which is listing an newly created table (last week) As David G. Johnston said how

Re: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped)

2024-11-15 Thread David G. Johnston
On Fri, Nov 15, 2024 at 12:46 PM Bharani SV-forum 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&#

Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped)

2024-11-15 Thread Bharani SV-forum
 Team Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped) The following is the query which i used, i am using and i found an bug which is listing an newly created table (last week) SELECT relnamespace::regnamespace::text AS schema_name, relname AS table_name FROM