判断表是否存在

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE XTYPE = 'U' AND NAME = 'AUTHORIZE_ORDER_HEADER') 
DROP TABLE AUTHORIZE_ORDER_HEADER
posted @ 2011-03-08 22:23  TNTZWC  阅读(173)  评论(0)  编辑  收藏  举报