title: Wipe out all data in a scheme, leave structure intact
body: <p>We're going to be going through a period of testing on a product soon.  This product is a web application with a SQL Server 2008R2 backend.</p>
  
  <p>Our database has several schemas within it (Customer, DataEntry, and a few others).</p>
  
  <p>I have found ways to <a href="http://www.mikemarks.net/blog/delete-all-data-from-a-database/" rel="nofollow">wipe all data in a database</a> without breaking referential integrity or the data structures, which is close to what we're looking to do.  The problem I'm finding is that we actually need a bunch of the data from some of the tables.  Essentially, we only want to wipe the Customers schema.</p>
  
  <p>We have a script written which will load in the test data for customers, but is there a way to change the techniques in my linked article to target only a specific schema?  Is there a better way to clear all data in a schema?</p>