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
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
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