根据表名的个数判断:
select count(name) as co from sysobjects where name = 'TD_RXNFDM'
查找苦中所有表的表名:
SELECT [name] FROM sysobjects WHERE type='u'
删除某表:
if exists (select name from sysobjects where name = '表名')
drop table 表名
根据表名的个数判断:
select count(name) as co from sysobjects where name = 'TD_RXNFDM'
查找苦中所有表的表名:
SELECT [name] FROM sysobjects WHERE type='u'
删除某表:
if exists (select name from sysobjects where name = '表名')
drop table 表名