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. Open the application.

  2. Select Administration, then Extended Analytics.

  3. From Destination Database (DSN), select the database that contains the star schema.

  4. For Relational Table Prefix, type the prefix that identifies the star schema’s tables.

    Note:

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

  5. Select Delete Star Schema.