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)<>'_'
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)<>'_'