Reverse Engineering partitions in Toad Data Modeler

Third Party Software

Reverse Engineering partitions in Toad Data Modeler

Hello,

I have a table definition in teradata(below) with partitions and I want to generate the sql code in Toad. When I generate the code I dont see the partitions on the table being truncated,disabled,rebuilt etc. I see no partition information on the code generation. Can you please tell me how I can solve this? I will do this generation for many tables so the work around can not be manual.

 

Thanks

 

CREATE MULTISET TABLE ORDER_DATA ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT

     (

      ORDER_NUM INTEGER NOT NULL,

      CUST_NUM INTEGER,

      ORDER_DATE DATE FORMAT 'YY/MM/DD',

      ORDER_TOT DECIMAL(10,2))

PRIMARY INDEX ( ORDER_NUM )

PARTITION BY ( RANGE_N(ORDER_DATE  BETWEEN DATE '2012-01-01' AND DATE '2012-12-31' EACH INTERVAL '1' DAY ),

CASE_N(

ORDER_TOT <  1000 ,

ORDER_TOT <  5000 ,

ORDER_TOT <  6000 ,

 NO CASE, UNKNOWN) );