-- drop a stored procedure if it exists
IF OBJECT_ID ( '[Common].[usp_MyStoredProcedure]', 'P' ) IS NOT NULL 
    DROP PROCEDURE [Common].[usp_MyStoredProcedure];
GO

-- drop a view if it exists
IF OBJECT_ID ( '[Common].[uvw_MyView]', 'V' ) IS NOT NULL 
    DROP VIEW [Common].[uvw_MyView];
GO

-- drop a function if it exists
IF OBJECT_ID ( '[Common].[ufn_MyFunction]', 'FN' ) IS NOT NULL 
    DROP FUNCTION [Common].[ufn_MyFunction];
GO

-- drop a user table if it exists
IF OBJECT_ID ( '[dbo].[myUserTable]', 'U' ) IS NOT NULL 
    DROP TABLE [dbo].[myUserTable];
GO

1.  -- drop a stored procedure if it exists 
2.  IF OBJECT_ID ( '[Common].[usp_MyStoredProcedure]', 'P' ) IS NOT NULL 
3.      DROP PROCEDURE [Common].[usp_MyStoredProcedure]; 
4.  GO 
5.   
6.  -- drop a view if it exists 
7.  IF OBJECT_ID ( '[Common].[uvw_MyView]', 'V' ) IS NOT NULL 
8.      DROP VIEW [Common].[uvw_MyView]; 
9.  GO 
10.   
11.  -- drop a function if it exists 
12.  IF OBJECT_ID ( '[Common].[ufn_MyFunction]', 'FN' ) IS NOT NULL 
13.      DROP FUNCTION [Common].[ufn_MyFunction]; 
14.  GO 
15.   
16.  -- drop a user table if it exists 
17.  IF OBJECT_ID ( '[dbo].[myUserTable]', 'U' ) IS NOT NULL 
18.      DROP TABLE [dbo].[myUserTable]; 
19.  GO 

AF	= Aggregate function (CLR)
C	= CHECK constraint
D	= DEFAULT (constraint or stand-alone)
F	= FOREIGN KEY constraint
FN	= SQL scalar function
FS	= Assembly (CLR) scalar-function
FT	= Assembly (CLR) table-valued function
IF	= SQL inline table-valued function
IT	= Internal table
P	= SQL Stored Procedure
PC	= Assembly (CLR) stored-procedure
PG	= Plan guide
PK	= PRIMARY KEY constraint
R	= Rule (old-style, stand-alone)
RF	= Replication-filter-procedure
S	= System base table
SN	= Synonym
SQ	= Service queue
TA	= Assembly (CLR) DML trigger
TF	= SQL table-valued-function
TR	= SQL DML trigger
TT	= Table type
U	= Table (user-defined)
UQ	= UNIQUE constraint
V	= View
X	= Extended stored procedure

1.  AF    = Aggregate function (CLR) 
2.  C    = CHECK constraint 
3.  D    = DEFAULT (constraint or stand-alone) 
4.  F    = FOREIGN KEY constraint 
5.  FN    = SQL scalar function 
6.  FS    = Assembly (CLR) scalar-function 
7.  FT    = Assembly (CLR) table-valued function 
8.  IF    = SQL inline table-valued function 
9.  IT    = Internal table 
10.  P    = SQL Stored Procedure 
11.  PC    = Assembly (CLR) stored-procedure 
12.  PG    = Plan guide 
13.  PK    = PRIMARY KEY constraint 
14.  R    = Rule (old-style, stand-alone) 
15.  RF    = Replication-filter-procedure 
16.  S    = System base table 
17.  SN    = Synonym 
18.  SQ    = Service queue 
19.  TA    = Assembly (CLR) DML trigger 
20.  TF    = SQL table-valued-function 
21.  TR    = SQL DML trigger 
22.  TT    = Table type 
23.  U    = Table (user-defined) 
24.  UQ    = UNIQUE constraint 
25.  V    = View 
26.  X    = Extended stored procedure