View Categories

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. 

Example of Table Layout

Example of View Layout

Tabs #

  • Actions #

    • Available for tables and views. Number of actions on views is limited. Read more…

  • Settings #

    • The most powerful features of WP Data Access! Read more…

  • 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.