/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 vote167 views1 answer
Sql count null as 0
SQL
0 vote167 views1 answer
Drop a field in psql django
SQL
0 vote179 views1 answer
Sql count more than 1
SQL
5 votes175 views2 answers
Oracle find all tables with column name
SQL
0 vote181 views1 answer
Import sql inside hide sql
SQL
3 votes164 views1 answer
Sql server check version
SQL
15 votes182 views6 answers
Psql
SQL
0 vote181 views1 answer
Postgresql comandos basicos
SQL
0 vote175 views1 answer
Mysql config address
SQL
38 votes174 views4 answers
Count sql
SQL