Test Data Management Self-Service Portal Guide

Back Next

SQL Queries to View and Edit Data

You can run SQL queries to view and edit data in a

data pack

The following table lists the queries that you can run along with sample syntax:

Query	Sample Syntax
SELECT *	SELECT * FROM <table_name>;
SELECT	SELECT <column_name>,<column_name> FROM <table_name>;
SELECT	SELECT <column_name> AS <alias_name> FROM <table_name>;
INSERT INTO	INSERT INTO <table_name> (column1,column2,column3) VALUES (value1,value2,value3); You must enter the column names. You cannot run the query without the column names.
UPDATE	UPDATE <table_name> SET column1=value1,column2=value2
DELETE FROM	DELETE FROM table_name WHERE <column_name>=<value>;
DELETE FROM	DELETE FROM table_name; Deletes all data in the table.