Test Data Management Self-Service Portal Guide

Back Next

Using the SQL Query Field to View and Manage Data

You can run an SQL query to edit the data in a

data pack

Open the required

data pack

Click the

Tables

tab.

Select the table that you want to update.

The table data appears in a grid in the

View Data

tab in the panel below the list of tables.

Optional. To view specific data, run an SQL query to select data based on required criteria.

Data that matches the criteria appears in the grid.

Enter the SQL query to insert, delete, or update the data in the

SQL Query

field and click

Run

The following image shows the

SQL Query

field on the

View Data

tab in the

data pack

page:

You can view the updated data in the grid.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.