For the last couple of years, Falafel Software has enjoyed a tremendous growth and success due to the hard work of its team worldwide.  On top of that list of hard workers is the company's Chief Technology Officer, John Waters. He has been a tremendous asset to the company and an incredible loyal friend.  With my medical story for the last 2 months, John has stepped up and ran the whole company in all aspects with tremendous success.

With me focusing in 2009 on my health and continue as Chief Executive Officer, while doing training and consulting, I have the pleasure of announcing the promotion of John Waters as the President & CTO of Falafel Software.  The team is thrilled about the well deserved promotion and we are looking at an another very successful year in 2009 under John's leadership.

John, congratulations and good luck.  Have fun and enjoy an incredible team of individuals that work extremely well together.

- Lino "The janitor" Tadros

Sometimes you want to clear out a database, but you can't just drop the entire database and create a new one. Recently, a colleague needed to do just that, but couldn't because the database was hosted elsewhere. Here is a simple script that works to drop all objects in any database I've tested it against so far. If your database contains object types that mine don't, you might need to add to this script using the same patterns established here.

declare @n char(1)
set @n = char(10)

declare @stmt nvarchar(max)

-- procedures
select @stmt = isnull( @stmt + @n, '' ) +
    'drop procedure [' + name + ']'
from sys.procedures

-- check constraints
select @stmt = isnull( @stmt + @n, '' ) +
    'alter table [' + object_name( parent_object_id ) + '] drop constraint [' + name + ']'
from sys.check_constraints

-- functions
select @stmt = isnull( @stmt + @n, '' ) +
    'drop function [' + name + ']'
from sys.objects
where type in ( 'FN', 'IF', 'TF' )

-- views
select @stmt = isnull( @stmt + @n, '' ) +
    'drop view [' + name + ']'
from sys.views

-- foreign keys
select @stmt = isnull( @stmt + @n, '' ) +
    'alter table [' + object_name( parent_object_id ) + '] drop constraint [' + name + ']'
from sys.foreign_keys

-- tables
select @stmt = isnull( @stmt + @n, '' ) +
    'drop table [' + name + ']'
from sys.tables

-- user defined types
select @stmt = isnull( @stmt + @n, '' ) +
    'drop type [' + name + ']'
from sys.types
where is_user_defined = 1

exec sp_executesql @stmt