根据表名的个数判断:
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 表名本文共 261 字,大约阅读时间需要 1 分钟。
根据表名的个数判断:
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 表名转载于:https://my.oschina.net/u/3647620/blog/1552324