RecorteX

solo tienes que reemplazar la ‘a’ por el texto que buscas, ejemplo ‘nombreusuario’ o ‘usuario’

descargar
 
DECLARE @txt VARCHAR(20)
SET @txt = 'a'
SELECT     O.name + '.' + C.name AS Nombre, C.column_id AS NumeroColumna, sys.types.name AS TipoDeDato, sys.types.max_length TamanoMaximo, sys.types.PRECISION AS PRECISION, sys.types.scale AS Escala, 
                      sys.types.is_nullable AS Nullable, sys.types.is_user_defined AS DefinidoPorUsuario
FROM         sys.columns AS C INNER JOIN
                      sys.objects AS O ON C.OBJECT_ID = O.OBJECT_ID INNER JOIN
                      sys.types ON C.user_type_id = sys.types.user_type_id AND C.system_type_id = sys.types.system_type_id
WHERE     (C.name LIKE N'%' + @txt + '%')
ORDER BY O.name, NumeroColumna
 

descargar
 
IF EXISTS (SELECT * FROM syscolumns WHERE id = object_id('tbl_clientes') AND name = 'cNumGrupo')
begin
	print('yes')
end