To delete a schema
Click Schema View.
Select the required schema that you want to delete.
Right-click the schema, and select Delete.
Alternatively, select the schema, and click Delete on the Schema menu.
A confirmation message appears.
Click Yes to delete the schemas.
You can click No to abort the deletion.
Note: If a schema is already in use in one transformation, it cannot be deleted from the DDW Repository.