---
title: "Manage tables & views"
description: "Click on the **Manage** link of a table or view on the Data Explorer main page to get access to table and view structures. Tables and views have different tabs and action buttons.  [![](https://wpdataaccess.com/wp-content/uploads/2021/04/data-explorer-manage-tabs.png)](https://wpdataaccess.com/wp-content/uploads/2021/04/data-explorer-manage-tabs.png) *Example of Table Layout* [![](https://wpdataaccess.com/wp-content/uploads/2021/04/data-explorer-manage-tabs-view.png)](https://wpdataaccess.com/wp-content/uploads/2021/04/data-explorer-manage-tabs-view.png) *Example…"
url: "https://docs.legacy.wpdataaccess.com/docs/database-administration/"
updated: "2025-11-26"
category: Data Explorer
---

# Manage tables & views

Click on the **Manage** link of a table or view on the Data Explorer main page to get access to table and view structures. Tables and views have different tabs and action buttons. 

  [![](https://wpdataaccess.com/wp-content/uploads/2021/04/data-explorer-manage-tabs.png)](https://wpdataaccess.com/wp-content/uploads/2021/04/data-explorer-manage-tabs.png)

*Example of Table Layout*

  [![](https://wpdataaccess.com/wp-content/uploads/2021/04/data-explorer-manage-tabs-view.png)](https://wpdataaccess.com/wp-content/uploads/2021/04/data-explorer-manage-tabs-view.png)

*Example of View Layout*

## Tabs

- #### **Actions**

  - Available for tables and views. Number of actions on views is limited. [Read more...](/docs/actions/)
- #### **Settings**

  - The most powerful features of WP Data Access! [Read more...](/docs/table-and-view-settings/)
- #### **Columns**

  - Read-only information showing table or view column characteristics. The plugin allows you to open multiple tabs simultaneously (see image below - click to enlarge).
- #### **Indexes**

  - Read only information. Only available for tables.
- #### **Foreign keys**

  - Read only information. Only available for tables.
- #### **SQL**

  - SQL create table or view statement. Can be copied to the users clipboard.

  [![](https://wpdataaccess.com/wp-content/uploads/2021/04/data-explorer-manage-columns.png)](https://wpdataaccess.com/wp-content/uploads/2021/04/data-explorer-manage-columns.png)