-Select Column name in Row

SELECT column_name, data_type, character_maximum_length, numeric_precision, NUMERIC_PRECISION_RADIX, numeric_scale
FROM Production.INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'table name'



-Find Stored Procedure with selected Table Name
SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%table name%'