Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. Appendix A: MX Views Reference

Repository Guide

Repository Guide

Dropping MX Views

Dropping MX Views

If you delete a repository, the Repository Service runs SQL scripts that drops the MX views. You can run the scripts from the Designer.
The following table lists the SQL scripts to drop MX views:
Repository Database
SQL Script
IBM DB2
db2mxdrp.sq_ and db2mxdr2.sq_
Microsoft SQL Server
sqlmxdrp.sq_ and sqlmxdr2.sq_
Oracle
oramxdrp.sq_ and oramxdr2.sq_
Sybase
sybmxdrp.sq_ and sybmxdr2.sq_
These SQL scripts are stored in the Repository Service installation directory.

0 COMMENTS

We’d like to hear from you!