/SQL/Buscar nombre de columna en todas las tablas sql server

Buscar nombre de columna en todas las tablas sql server

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

Source: vhspiceros.blogspot.com

Similar codes

13 votes264 views3 answers
List all the tables in sql
SQL
1 vote234 views1 answer
How to between in sql
SQL
0 vote236 views1 answer
Mysql workbench not showing schemas
SQL
9 votes243 views1 answer
Sql server get utc date
SQL
0 vote248 views1 answer
Restore backup mysql .gz
SQL
0 vote238 views1 answer
Mysql select smaller of two values
SQL
0 vote245 views1 answer
Postrgres trunc
SQL
0 vote255 views1 answer
How to know if table in rigt or left in sql
SQL
1 vote247 views1 answer
Sql where max date
SQL
0 vote233 views2 answers
Install phoenix
SQL