摘要： --get all user's tables获取所有的用户表create table #tempTabelInfo(Id int identity(1,1) primary key not null,DBName nvarchar(100) not null,TableName nvarchar(100) not null)gosp_msforeachdb 'use [?]if db_id()>4begininsert into #tempTabelInfo select db_name() as DBName,name as TableName from sysobj 阅读全文