MSSQL 判断实例中是否存在某种表

执行语句

SELECT ‘SELECT * FROM ‘+Name+‘..SysObjects Where XType=‘‘U‘‘ and name=‘‘tab_scartrim‘‘ ORDER BY Name‘ FROM Master..SysDatabases ORDER BY Name

生成如下语句
SELECT * FROM ********************..SysObjects Where XType=‘U‘ and name=‘tab_scartrim‘ ORDER BY Name
SELECT * FROM ********************..SysObjects Where XType=‘U‘ and name=‘tab_scartrim‘ ORDER BY Name
SELECT * FROM ********************..SysObjects Where XType=‘U‘ and name=‘tab_scartrim‘ ORDER BY Name

进行二次查询就能知道什么数据库存在表了

MSSQL 判断实例中是否存在某种表

原文：http://www.cnblogs.com/Impulse/p/4834580.html