SDU Tools 170 Create Empty and Drop Schema

SDU Tools are free tools and provide example T-SQL code for SQL Server developers and DBAs. CreateOrEmptySchema creates a schema if it doesn't already exist, or removes all objects from the schema if it does. Either way, you end up with a schema with no objects in it. EmptySchema can be used when you have an existing schema and just want to remove all objects from it. DropSchema removes all objects from a schema and then drops it. In each case, if there are incoming or outgoing foreign key relationships, they are removed first. To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com