Check out example codes for "buscar nombre de columna en todas las tablas sql server". It will help you in understanding the concepts better.

Code Example 1

SELECT AS table_name, AS column_name,
  AS datatype, syscolumns.LENGTH AS LENGTH
FROM       sysobjects INNER JOIN
               syscolumns ON = INNER JOIN
               systypes ON syscolumns.xtype = systypes.xtype
WHERE     (sysobjects.xtype = 'U') 
                and (UPPER( like upper('%myFieldName%'))
ORDER BY, syscolumns.colid

Learn ReactJs, React Native from