/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

0 vote244 views1 answer
No query unable to fetch row sqlite
SQL
0 vote225 views1 answer
Postgresql certain first 4 characters in string
SQL
3 votes213 views2 answers
Having in mysql
SQL
0 vote219 views1 answer
Sql server manager close connection
SQL
3 votes237 views1 answer
Postgresql today - 1 year
SQL
0 vote207 views1 answer
Postgresql newline character
SQL
2 votes256 views3 answers
Postgres json to string
SQL
2 votes229 views1 answer
Laravel sql String
SQL
10 votes227 views1 answer
Oracle dba_dependencies
SQL
0 vote223 views1 answer
Uuid sqlalcomany
SQL