SQL Test runs tests depending on what is selected in the SQL Test interface.

Running all tests for a database

To run all the tests for a database, make sure the database is selected in the SQL Test interface, and click :

Running a test class

To run a group of tests in a test class, make sure the test class you want to run is selected, and click :

Running a single test

To run a single test, make sure the test you want to run is selected in the SQL Test interface, and click .

Alternatively, right-click the test, and click Run Test:

Test status indicators

In the SQL Test list, the icon before the test name displays the status of the test:

	There is no result for this test. Either this is a new test you've created, or a test you haven't run since you launched SQL Test.
	When the test was last run, it passed.
	When the test was last run, it failed.

Editing a test

To script out a test as an ALTER PROCEDURE query, double-click the test in the SQL Test tab.

Alternatively, you can right-click a test in the SQL Test tab, and click Edit Test.

Renaming a test or test class

To rename a test or test class:

1. In the SQL Test tab, select the test or class you want to rename, and press F2.
2. Type a new name, and press Enter.

Deleting a test

To delete a test from the database:

1. in the SQL Test tab, select a test, and press the Delete key.
   Alternatively, you can right-click a test in the SQL Test window, and click Delete Test:
    
2. On the confirmation dialog box, click Yes.