Deleting a Star Schema

You can delete a star schema that you no longer need. Deleting a star schema deletes all of the star schema data, metadata, and tables.

To delete a star schema:

1. Select Consolidation, then Extract, and then Data.
2. From Extract Destination Type, select Database.
3. From Destination Database (DSN), select the database that contains the star schema.
4. For Relational Table Prefix, enter the prefix that identifies the star schema’s tables.

   Note:

   The prefix can contain up to 10 alphanumeric characters and must start with a letter. The default prefix is the application name.

5. From Schema Actions, select Delete Star Schema.