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