I have lots of materialized views, and I routinely define a primary key on each.
(It ’ s a table; a table should have a primary key.)
I can ’ t find a way in TOAD to have it generate a complete script for
such an object. If I generate the script from the MV tab of the Schema Browser,
I can ’ t get the primary key (the most I can get is a CREATE UNIQUE
INDEX); if I generate the script from the Table tab, I get the primary key, but
of course I don ’ t get the MV query.
Is there a way?
US Seed & Trait Commercial IT - Data Management Team
800 N. Lindbergh Blvd. LC4D - Saint Louis, MO - 63167
This e-mail message may contain privileged and/or confidential information, and
is intended to be received only by persons entitled to receive such information.
If you have received this e-mail in error, please notify the sender immediately.
Please delete it and all attachments from any servers, hard drives or any other
media. Other use of this e-mail by you is strictly prohibited.
All e-mails and attachments sent and received are subject to monitoring, reading
and archival by Monsanto, including its subsidiaries. The recipient of this
e-mail is solely responsible for checking for the presence of “Viruses” or other
“Malware”. Monsanto, along with its subsidiaries, accepts no liability for any
damage caused by any such code transmitted by or accompanying this e-mail or any