/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

14 votes292 views2 answers
Oracle add column with default value
SQL
8 votes308 views1 answer
Oracle search stored procedures for text
SQL
3 votes284 views2 answers
Tsql join multiple record in one string
SQL
0 vote274 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote280 views1 answer
Sql server separar numeros por comas miles
SQL
8 votes279 views2 answers
Alert table name mysql
SQL
15 votes272 views2 answers
Install mysql 8 ubuntu 18.04
SQL
0 vote295 views1 answer
How to delete python anywhere mysql database
SQL
0 vote287 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote273 views1 answer
Group_concat only returns one row
SQL