/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 vote185 views1 answer
Mysql docker image arjun
SQL
0 vote201 views1 answer
Codigo crear tablas sql server
SQL
123 votes1.1K views5 answers
Sql where contains
SQL
-1 vote198 views3 answers
Compute age mysql
SQL
0 vote180 views1 answer
Jenkins SQLCMD run
SQL
15 votes163 views4 answers
T-sql drop function if exists
SQL
0 vote165 views1 answer
Tsql generate rows
SQL
0 vote161 views1 answer
Count the table indatabase
SQL
0 vote170 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
1 vote183 views2 answers
Pad zero sql server
SQL