Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Data Type Reference for Hadoop
  23. Glossary

Using the SQL Query Field to View and Manage Data

Using the SQL Query Field to View and Manage Data

You can run an SQL query to edit the data in a data set.
  1. Open the required data set.
  2. Click the
    Tables
    tab.
  3. Select the table that you want to update.
  4. Click the
    View Data
    tab in the panel below the list of tables.
    The table data appears in a grid.
  5. 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.
  6. 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 set page:
    The View Data tab in the data set page shows the SQL Query field with a query to select all records from the Address table. The View Data tab contains buttons to add and delete rows and update tags.
    You can view the updated data in the grid.