/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

12 votes345 views2 answers
Update column data type postgres
SQL
0 vote543 views1 answer
Multiple row join
SQL
0 vote345 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
0 vote352 views1 answer
Sql if clause within where clause
SQL
0 vote345 views1 answer
Shell script to log mysql cpu usage
SQL
3 votes377 views1 answer
Postgres count distinct
SQL
2 votes333 views2 answers
Postgres select duplicate columns
SQL
-1 vote348 views1 answer
Module operator in oracle sql
SQL
1 vote335 views2 answers
T sql get foreign key
SQL
0 vote332 views1 answer
Sql gap missing values
SQL