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. MX Views Reference
  17. PowerCenter Reports 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!