SQLSERVER 查询某张表属于哪个数据库
表名:dt_article_albumsexec sp_MSforeachdb @command1='USE ? if exists(SELECT 1 from sysobjects where id=object_id(''dt_article_albums'')) PRINT ''?'''
·
表名:dt_article_albums
exec sp_MSforeachdb @command1='USE ? if exists(SELECT 1 from sysobjects where id=object_id(''dt_article_albums'')) PRINT ''?'''
更多推荐
已为社区贡献1条内容
所有评论(0)