Assuming less is required, the following 41 results were found.
Drop If Object Existshttp://mail.joellipman.com/articles/database/t-sql/drop-if-object-exists.html
it exists IF OBJECT_ID ( '[dbo].[myUserTable]', 'U' ) IS NOT NULL DROP TABLE [dbo].[myUserTable]; GO Types for sys.objects (less used by me) AF = Aggregate function (CLR) C = CHECK constraint D = DEFAULT (constraint or stand-alone) F = FOREIGN KEY...