Toad World® Forums

DDL for Mat View doesn't include indexes


As stated, if you do a Ctrl-D, you don’t get the indexes for the mat view included. It doesn’t show in the Navigator either.

However, it does work if you open in the object editor if you click on the icon or if you do a ctrl-d


Hi joethejet,

Thanks for your feedback, we have created a enhancement(SQLNAV-1952 :Extract DDL for Materialized View doesn’t include indexes and comments) for you, thanks.