/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 vote138 views2 answers
Pl sql case
SQL
0 vote107 views2 answers
Avg() sql
SQL
0 vote148 views1 answer
Mysql grouping functions
SQL
0 vote132 views1 answer
Sql comand for removing data from table
SQL
0 vote184 views1 answer
Cahnge column name apex oracle
SQL
21 votes146 views4 answers
Oracle add column
SQL
0 vote142 views1 answer
Redudancy in SQL
SQL
0 vote93 views1 answer
Get all stored procedures in sql server
SQL
5 votes139 views2 answers
Sql create tabel with primary key auto_increment code
SQL
0 vote437 views1 answer
How to connect .sql data set to powerbi
SQL