Query to find out list of tables which has a particular column....

Below query is used to find out the list tables which has particular column.

SELECT OBJECT_NAME(OBJECT_ID) FROM SYS.COLUMNS  SC

WHERE NAME LIKE '%CUSTID%'