Index

  1. Home
  2. Docs
  3. Index
  4. Data Explorer
  5. Manage tables and views

Manage tables and 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. Click the image left for an example of the table layout and the image right for an example of the 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 to open multiple tabs simultanously (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.

 

Was this article helpful to you? Yes 2 No

5 Replies to “Manage tables and views”

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

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

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

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

Leave a Reply

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

20 − 8 =