Database Maintenance

Owned by Matthew Wagner
Last updated: Sept 15, 2017

In the Database Connections panel, you can view information from the database(s) being used by XperienCentral. You can view the database's metadata as well as a list of all the tables in the database(s). By selecting a table from the list, you can see the fields it contains and the format of those fields. You can also query the database in order to retrieve the current value of a specific field or fields as well as to alter the structure of the database.

 

In This Topic

 

Database Metadata

Select a database from the drop-down list to view its properties:





In the example above the XperienCentral database is selected. In the "Database Connection Metadata" section, the following information is shown:

MetadataDescription
NameThe name of the database.
JNDI ResourceThe name of the JNDI resource used by the database.
Product nameThe manufacturer of the database (Oracle, MySQL, etc.).
Product versionThe major.minor version number of the database.
Driver nameThe name of the database driver.
Driver versionThe major.minor version of the database driver.

 

For example:

 

 

Back to top

 

Database Tables

In the "Tables" section, a selectable list of all the tables in a database is available. To see a summary of the fields in a database table, click it. The information that is shown for the fields in a table vary by database. The following is an example of the fields belonging to a table in a MySQL database:

 

 

 

The fields of the table are shown along with the following information:

 

FieldDescription
NameThe name of the database field.
Data typeThe type of data stored in the field (INT, VARCHAR, and so forth)
LengthThe length of the field in bytes.

 


Back to top

 

Table Queries

You can enter Structured Query Language (SQL) statements in order to manage a database and retrieve the values of fields in a database's tables on the "Query" tab.

 

Use extreme caution when executing SQL statements such as DELETE, JOIN, and others that can affect the structure of the database and/or tables and fields because doing so could have an adverse affect on your website(s).

 

To perform a query, follow these steps:

  1. Select the database to query from the "Database" drop-down list.
  2. To limit the results to a specific amount, enter a value in the "Maximum number of records to be returned" field.
  3. In the "Query" field, enter a Structured Query Language (SQL) statement and then click [Execute query]. The result is displayed in the "Query Results" section. For example:





    If the query does not retrieve values (by an UPDATE, for example), the result(s) of the query on the database will be shown. For example:






Back to top