...
In the example above the XperienCentral database is selected. In the "Database Connection Metadata" section, the following information is shown:
| Metadata | Description |
|---|---|
| Name | The name of the database. |
| JNDI Resource | The name of the JNDI resource used by the database. |
| Product name | The manufacturer of the database (Oracle, MySQL, etc.). |
| Product version | The major.minor version number of the database. |
| Driver name | The name of the database driver. |
| Driver version | The major.minor version of the database driver. |
...
The fields of the table are shown along with the following information:
| Field | Description |
|---|---|
| Name | The name of the database field. |
| Data type | The type of data stored in the field (INT, VARCHAR, and so forth) |
| Length | The length of the field in bytes. |
...
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.
...
| Warning |
|---|
Use extreme caution when using 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). |
...