exec sp_MSforeachdb @command1=‘USE ? if exists(SELECT 1 from sysobjects where id=object_id(’‘表名’’)) PRINT ‘’?’’’
SQLServer 查询某个表存在于哪几个数据库
最新推荐文章于 2022-11-11 10:23:35 发布
exec sp_MSforeachdb @command1=‘USE ? if exists(SELECT 1 from sysobjects where id=object_id(’‘表名’’)) PRINT ‘’?’’’