/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

9 votes186 views4 answers
Add primary key to existing table sql
SQL
0 vote191 views1 answer
How to add timestamp column in mysql
SQL
2 votes219 views2 answers
Python escape string for sql
SQL
1 vote200 views1 answer
Median mysql
SQL
6 votes295 views1 answer
Check Table Exists
SQL
0 vote180 views1 answer
2020 new year
SQL
0 vote187 views1 answer
Mysql milliseconds
SQL
7 votes202 views2 answers
Where keyword sql
SQL
0 vote196 views1 answer
Geopoint from json mysql function
SQL
0 vote178 views1 answer
Sqlite closes value
SQL