Toad World® Forums

Best way to handle PARTITIONed table

Partitions are created and dropped at run-time, so there isn't any way to put them all in the Diagram (this would be a lot of clutter in any case). But I would like some symbolic representation of a relationship between a master table and a sample partition.

What do people suggest?

If you need just logical relationship you have to choice.

  1. Use note line with some label
  2. Use relationship and unselect Generate checkbox on Relatinship Dialog