查询数据库中存在指定字段的表

select 'select * into '+b.name+ '00  from ' +b.name+ ' where sch_id=''111'''
from syscolumns a,sys.objects b
where a.name = 'sch_id'
  and a.id = b.object_id
  and b.type = 'U' and substring(b.name,1,1)<>'_'