TestSchema_Clear.ssunit.sql File Reference

The TestSchema_Clear stored procedure. More...

Functions
int	TestSchema_Clear (@schemaName ssunit.SchemaName=null--!< The schema used for the tests.)
	Clears the named schema of all objects.

---

Detailed Description

The TestSchema_Clear stored procedure.

Author:

Chris Oldwood

---

Function Documentation

int TestSchema_Clear

(

)

Clears the named schema of all objects.

This helper procedure makes it easier to avoid those nasty errors that crop up when there are bugs in the setup/teardown procedures or your tests when you're first writing them. It deletes all objects from the schema so that when you run your test script you can guarentee that you're starting from a clean slate.

Note:

By default it clears all objects from the default test schema which is called 'test'.