Is it possible to show only the main table with partitions, not individually partitioned tables

pete's profile image pete posted 4 years ago in General Permalink

Is it possible to show only the main table with partitions, not individually partitioned tables? example is new DB set up and this 1 table has initially 100 partitions, so it has main table displaying and 100 others for each partition.

Can i just show the main table? this db has roughly 100 tables, but because it is showing all that are partitioned, it has over 4k.

Thanks

Peter

2 attachment(s):
  • Capture
  • Capture2

Please login to leave a reply, or register at first.