How do I indicate a table entity is a partition table in the model?
To add a partition to a table entity by entering the code manually in the “Table Properties”.
Open the Entity Properties and click on the Table Properties tab and enter in the code.
For example, to indicate a table is a partition by entering the SQL script in the properties field:
PARTITION BY RANGE("COLUMN_NAME")
(
-- Partition "PARTITION_NAME"
PARTITION " PARTITION_NAME" VALUES LESS THAN (MAXVALUE)
STORAGE(
INITIAL 64K
MAXEXTENTS UNLIMITED
FREELISTS 1
FREELIST GROUPS 1
)
)
Even if you were to reverse engineer an existing partition table, all the information will be stored in the Table Properties tab as well as code as shown above.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center