Class WPDA_Table_Actions

author Peter Schulz
since 2.0.13
package WPDataAccess\Utilities

 Methods

Shows the specifications for the specified table or view

show() 

There are four tabs provided:

TAB Actions Provides actions for the given table or view, like export, rename, copy, drop, alter, and so on. A button is provided for every possible action. For some actions additional info can be provided through input fields like the type of download for an export. Not all buttons are available for all tables and views. WordPress tables for example cannot be dropped. Views for example can not be truncated. Which buttons are provided depends on the table or view.

TAB Structure Shows the columns and their attributes.

TAB Indexes Shows the indexes for the specified table. Not available for views.

TAB SQL Shows the create table or views statement for the given table of view. A button is provided to copy this statement to the clipboard.

since 2.0.13

Provides content for table settings

tab_settings() 

Provides content for tab Actions

tab_actions() 

Provides content for Alter action

tab_alter() 

Provides content for Copy action

tab_copy() 

Provides content for Drop action

tab_drop() 

Provides content for Export action

tab_export() 

tab_foreign_keys()

tab_foreign_keys() 

Provides content for tab Indexes

tab_index() 

Provides content for Optimize action

tab_optimize() 

Data_length Index_length Data_free

Provides content for Rename action

tab_rename() 

Provides content for tab SQL

tab_sql() 

Provides content for tab Structure

tab_structure() 

Provides content for Truncate action

tab_truncate() 

 Properties

 

Reformatted create table statement

$create_table_stmt : string

Default

 

Original create table statement

$create_table_stmt_orig : string

Default

 

Possible values: Table and View

$dbo_type : string

Default

 

Database foreign key constraints

$foreign_keys : array

Default

 

Database indexes

$indexes : array

Default

 

Indicates if table is a WordPress table

$is_wp_table : boolean

Default

 

Row number in the list table

$rownum : integer

Default

 

Database schema name

$schema_name : string

Default

 

Database table name

$table_name : string

Default

 

Database table structure

$table_structure : array

Default

 

Handle to instance of WPDA_List_Columns

$wpda_list_columns : \WPDataAccess\Data_Dictionary\WPDA_List_Columns

Default