Cercar tots els camps que contenen el texte TEXTE dintre del nom del camp:
SELECT c.name AS 'Camp', t.name AS 'Taula' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE '%TEXTE%' ORDER BY Taula,Camp;
Cercar tots els camps que contenen el texte TEXTE dintre del nom del camp:
SELECT c.name AS 'Camp', t.name AS 'Taula' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE '%TEXTE%' ORDER BY Taula,Camp;