/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

1 vote291 views1 answer
STOP message of how many rows affected sql
SQL
1 vote261 views1 answer
Postgresql create table with timestamp
SQL
0 vote266 views1 answer
Mysql c commands
SQL
0 vote254 views1 answer
Can sqldatareader be null
SQL
4 votes256 views1 answer
Wildcard in sql
SQL
0 vote259 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote257 views1 answer
Mysql count number of occurrences in a column
SQL
11 votes262 views4 answers
MYSQL LOGIN
SQL
0 vote265 views2 answers
MySQL PARTITION BY month automatically
SQL
18 votes258 views3 answers
Find column name in database
SQL