Find Tables in a Database Who Have a Filed With Same Name

SELECT SCHEMA_NAME(schema_id) + '.' + t.name AS 'Table Name'

FROM sys.tables t

     INNER JOIN sys.columns c

        ON c.object_id = t.object_id

WHERE c.name like '%OrderID%'

ORDER BY 'Table Name'