We have a table that is growing quickly and would like to partition it
by date. However, the table does not have a date field. With another
table, we are able to create a link to bring in the date.

Is it possible to create a table that is partitioned by date from a
field in a different table?

Hope that is clear.

-JB

Justin wrote:

We have a table that is growing quickly and would like to partition it
by date. However, the table does not have a date field. With another
table, we are able to create a link to bring in the date.
>
Is it possible to create a table that is partitioned by date from a
field in a different table?

No, you have to use a column in the physical table.