Easy way to clear your SQL server database 18 May 2012 Guus-Beltman SQL Sometimes you want to make a clean start with your SQL server database since it’s filled up with old demo data. We all now that you can delete or truncate your tables easily by executing some T-SQL statements. When you only have a couple of tables and no complex foreign key dependencies you can do it by hand. When you database is larger and for more complex it can be a time consuming task and it’s different for each database schema. The following script makes it really easy (beware: select the correct database!). 1: -----------------------------------------------------------... [More]