Get columns data

SELECT OBJECT_NAME(object_id) as TableName, 

     TYPE_NAME(system_type_id) as system_type_name,

* 

FROM sys.columns

--WHERE name = 'COLUMN_NAME'

--WHERE name LIKE '%abcd%'

--WHERE OBJECT_NAME(object_id) = 'TABLE_NAME'
-- and more.....

ORDER BY OBJECT_NAME(object_id)