Search Snippets

Find Field

SELECT sc.name sc_name,so.name so_name, sc.*
FROM dbo.syscolumns sc
INNER JOIN dbo.sysobjects so ON sc.id = so.id
--WHERE so.id = [id XXXXX]
WHERE sc.name LIKE '%[field_id]%'
ORDER BY sc.name
;