/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 vote147 views1 answer
Sql server count all tables rows
SQL
0 vote199 views1 answer
How to compile a function in oracle
SQL
0 vote134 views1 answer
Dump multiple tables mysql
SQL
10 votes117 views2 answers
Sql where clause multiple values
SQL
0 vote140 views1 answer
Distinct data types in a table sql query
SQL
0 vote149 views1 answer
Sql auto_increment syntax
SQL
-1 vote149 views1 answer
Auto increment psql not primary key
SQL
0 vote142 views1 answer
Insert or update sql query
SQL
3 votes181 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
2 votes144 views1 answer
Sql server case sensitive search
SQL