判断表是否存在

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 阅读(15) 评论(0) 编辑 收藏