WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
Select Page
Popular Search formimportsqlqueryexport

WP Data Access

  • Getting started
  • Installation
  • What’s new?
  • Patches
  • Known limitations
  • FAQ

Data Tables

  • Getting Started
  • Creating and publishing
  • Responsive data tables
  • SEO friendly data tables
  • Adding hyperlinks
  • Extension Manager
  • Style Manager
  • Language settings
Styling
  • Style Manager
  • Premium styling
  • Global styling
  • Code Manager Styling
  • Manual styling
  • Styling issues
Filters
  • Static filters
  • Interactive filters
    • URL parameters
    • Search Panes
    • Search Builder
    • Search form
    • Advanced search
    • Geolocation search
Export & other buttons
  • Export to PDF, CSV, Excel, SQL
  • Print & copy buttons
  • Column selection buttons
  • Custom buttons
Advanced features
  • Advanced settings
  • Large tables & performance
  • Progressively SHOW MORE
  • Custom queries
  • Custom Post Types
  • Row grouping
  • Responsive master-detail
  • Master-detail tables
  • Non admin user access
Demos & tutorials
  • Demos
  • Tutorials

Data Apps

  • Data Projects
  • Projects and templates
  • Supported Data Types
  • One-To-Many relationships
  • Many-To-Many relationships
  • Registration page
  • Manage table options
  • Shortcode usage
Project Templates
  • Project Templates
  • Creating templates
  • Table Settings
  • Relationships
  • List Table
  • Data Entry
  • Reconcile
Data Forms
  • Data Forms
  • Overview
  • Project Demo
  • Page Demo
Advanced features
  • Adding filters
  • Custom validation
  • Add less/more button
  • User roles
  • Managing roles and users
  • Advanced table options
  • Advanced lookups
  • Front-end toolbar
  • Transfer to other WP site
Demos & tutorials
  • Demos
  • Tutorials

Data Explorer

  • Getting started
  • Navigation
  • Explore tables & views
  • Manage tables & views
  • Naming conventions
Manage Actions
  • Actions
Manage Settings
  • Settings
  • Table Settings
  • Column Settings
  • Search Settings
  • Geolocation Settings
  • Dynamic Hyperlinks
  • Dashboard Menus
Data Management
  • Import CSV & SQL files
  • Run SQL script files
  • Data Backup
Problems & solutions
  • InnoDB #rows estimation
  • Import file too large
  • Transfer to other WP DB

Remote Databases

  • MySQL | MariaDB
Other DBMS
  • Heterogeneous Connections
  • Using ODBC | JDBC
  • Connect to SQL Server
Premium Data Services
  • Remote wizard
  • START HERE
  • Errors and messages
  • Limitations
  • Tutorials
  • Remote Databases
    • Remote databases
    • SQL Server
    • PostgreSQL
    • Oracle
    • MariaDB | MySQL
    Remote Data Files
    • Remote data files
    • CSV files
    • JSON files
    • MS Access
    • XML files
    • Public URL
    • Synchronization
    Advanced features
    • Performance
    • Indexes

SQL

  • Getting Started
  • Tutorials
  • Visual Query Builder
  • Writing queries
  • Data exchange
  • Stored procedures
  • Database triggers
  • Scheduled queries

Business Intelligence

  • Getting started
  • Dashboards
  • Sharing dashboards
Dashboards Widgets
  • Dashboard Widgets
  • Publication Widget
  • Project Widget
  • Chart Widget
  • Custom Code Widget
  • Database Widget
  • Sharing Widgets

Table Design

  • Getting started
  • Introduction
  • Basic mode

Plugin Settings

  • Getting started
  • Plugin
  • Back-end
  • Front-end
  • Dashboard
  • Data Forms
  • Data Tables
  • Data Backup
  • Uninstall
  • Manage Repository
  • Manage Roles
  • System Info

Code

Shortcodes
  • Overview
  • wpdataaccess
  • wpdadataproject
  • wpdadataforms
  • wpdadiehard
  • wpdageomap
  • wpdawidget
Hooks & filters
  • Overview
  • Hooks
    • Overview
    • wpda_add_search_actions
    • wpda_add_search_filter
    • wpda_before_list_table
    • wpda_after_list_table
    • wpda_wpdataaccess_prepare
    Filters
    • Overview
    • wpda_column_default
    • wpda_before_simple_form
    • wpda_after_simple_form
    • wpda_construct_where_clause
API
  • WP Data Access API
  • Remote database access
  • CRUD Example
  • Extensions
    • Alternative search algorithm
    • Alternative buttons extension
Code Manager
  • Overview
  • Write code
  • Share(d) code

Manage tables & views

Table of Contents
  • Tabs
    • Actions
    • Settings
    • Columns
    • Indexes
    • Foreign keys
    • SQL

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. 

WP Data Access - Data Explorer Manage Tabs

Example of Table Layout

WP Data Access - Data Explorer Manage Tabs for View

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.
WP Data Access - Data Explorer Manage Columns
Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2022-12-15
Explore tables & viewsNaming conventions

7 Comments

  1. Jeff
    Jeff on 2020-01-15 at 2:10 pm

    Installed WP Data Access to siteground site.
    Entered basic table info (event_vendors)
    Click on Create table and I get a dialog with:
    Create database table “?
    Does not create indexes!

    I have entered event_vendors for the table name and added
    and id column, company column, and name column.
    Trying to see if this plugin will allow me to create a couple of tables that will
    track vendors that are registering to have a booth a given conference.
    But, I can’t get past this error.
    I have gone as far as supplied around 20 columns, specifying the column type, key, mandatory, max length, default value for the column and it is ever does create a table…Only the 1st column is ever registered. I’ve tried this at least 15 times without success. Only once did a table get created – when I prefixed it with “wp_”…but it only had the id column.

    Reply
  2. Peter Schulz
    Peter Schulz on 2020-01-15 at 3:57 pm

    Hi Jeff,

    This is just a message to inform you that the plugin will create the table, but it won’t create any indexes. In your case this does not make any difference since you have no indexes. You only have a primary key (on your id) which will be created when you create the table. Just keep in mind that you will need to create indexes separately.

    How to continue:
    Click button CREATE TABLE and click OK. The table will be created. You can check the result in the Data Explorer. After that you can use your table in a Data Project of Data Publication.

    Hope this helps! Let me know if you need more assistance.

    Best regards,
    Peter

    Reply
  3. Lorenzo
    Lorenzo on 2021-01-27 at 1:28 pm

    Hi,
    how do I create foreign keys?
    I see them here, but I don’t understand how to create them in Data Designer.
    I don’t know if this is relevant in terms of capabilities, but I am a premium user.
    Kind regards

    Lorenzo

    Reply
    • Peter Schulz
      Peter Schulz on 2021-01-28 at 2:24 pm

      Hi Lorenzo,

      The Data Designer does support foreign key constraints. It’s on my to do list with low priority. Let me explain why…

      There are many WordPress installations using different DBMSs and table types. Foreign key constraints are not available for all these installations. To allow WordPress users to create parent/child forms for any table type and any DBMS version, I decided to create my own foreign key logic. You can use this logic by adding a relationship to your project template (tab relationships).

      On the downside the plugin does not handle cascading updates and cascading deletes are handled over one level only. On the upside WP Data Access allows users to create parent/child forms for any table type with any MySQL or MariaDB database version.

      Does this make sense?

      Best regards,
      Peter

      Reply
  4. Bodytayb
    Bodytayb on 2021-01-31 at 3:08 pm

    tables not showing on table list when accessing Data Tables

    Reply
  5. Eve
    Eve on 2022-11-03 at 2:58 pm

    Hi!
    I’ve been trying out the plugin and I’m really impressed with all it can do! I just have a weird problem occur: the Manage button (you know, the one right next to Explore under each database) has disappeared in my Data explorer view. I don’t recall changing any settings that would impact this. How do I get it back? It’s impossible to define dynamic links without it.

    Reply
    • Peter Schulz
      Peter Schulz on 2022-11-03 at 4:18 pm

      Hi Eve,

      Good you’ve been trying out the plugin! I guess while testing some options you might have disabled the Manage link… You can easily enable it again. Please go to plugin settings > tab Back-end and unselect option “Restrict table management” for your account. To unselect all accounts, you need to hold down the control key for the last item.

      Hope this helps,
      Peter

      Reply

Submit a Comment Cancel reply

Your email address will not be published. Required fields are marked *

Table of Contents
  • Tabs
    • Actions
    • Settings
    • Columns
    • Indexes
    • Foreign keys
    • SQL

Links

Blogs
Tutorials
Demos

Socials

LinkedIn
Twitter

Get in touch

Premium support
Free support forum
Contact us

Resources

WordPress plugin directory
YouTube tutorials

Passionate Programmers B.V. © 2017 - 2023 All rights reserved