# How to Convert to Database Views

If your CopyStorm database was created before Database Views were introduced then are likely many database tables in your backup that could be represented as database views instead. For safety, CopyStorm will not convert an existing table to a view UNLESS you follow the instructions in this article.

## The DBA Approach

The technique to force CopyStorm to switch to a database view for a table is simple:

* Manually drop the table in the CopyStorm database that should be a view. The next time CopyStorm runs it will create the view.

For example:

* DROP TABLE AccountFeed
* DROP TABLE ActivityHistory

will cause CopyStorm to recreate AccountFeed and ActivityHistory to views the next time CopyStorm runs.

## The Non-DBA Approach

The [CopyStorm/Medic Table Editor](/reference/copystorm-medic/table-editor.md) tool provides a simple GUI for dropping tables from a CopyStorm database.

* Go to the documentation for the [CopyStorm/Medic Table Editor](/reference/copystorm-medic/table-editor.md)

## What Tables Can Be Converted To Database Views?

* All tables ending with Feed. Examples:
  * AccountFeed
  * MyCustomObject\_\_Feed
* ActivityHistory
* AccountUserTerritory2View


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://learn.capstorm.com/frequently-asked-questions/how-does-copystorm-work/how-do-copystorm-views-work/how-to-convert-to-database-views.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
