判断表是否存在

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE XTYPE = 'U' AND NAME = 'AUTHORIZE_ORDER_HEADER') 

DROP TABLE AUTHORIZE_ORDER_HEADER