sp_Msforeachdb is not realiable, it is not fetching details from few other DBs

EXEC sp_Msforeachdb ‘if exists(select object_name(SC.object_id) ”Table”,len(ST.name) ”TableLength”,SC.Name ”Column”,len(SC.name) ”ColumnLength”
from [?].sys.columns SC inner join [?].sys.tables ST on SC.OBJECT_ID=ST.OBJECT_ID and ST.type=”U”
where len(SC.name)>30 or len(ST.name)>30)
select ”?” as FoundInDb,object_name(SC.object_id) ”Table”,len(ST.name) ”TableLength”,SC.Name ”Column”,len(SC.name) ”ColumnLength”
from sys.columns SC inner join sys.tables ST on SC.OBJECT_ID=ST.OBJECT_ID and ST.type=”U”
where len(SC.name)>30 or len(ST.name)>30’

another script
EXEC sp_Msforeachdb ‘select object_name(SC.object_id) ,len(ST.name) ,SC.Name ,len(SC.name)
from sys.columns SC inner join sys.tables ST on SC.OBJECT_ID=ST.OBJECT_ID and ST.type=”U”
where len(SC.name)>30 or len(ST.name)>30’

–Test

drop table ManishManishManishManishManishManishManish
create table dbo.ManishManishManishManishManishManishManish  ( idasdfdhasfdasfdasjhfjdashfjkdhlsfdhasfjkdhsflkdfa1 int)