/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 vote157 views1 answer
Insert value to new table by joining 2 different tables
SQL
1 vote147 views2 answers
Mysql remove first and last character from string
SQL
0 vote143 views4 answers
How to connect form to database
SQL
0 vote135 views1 answer
Sql server get date of previous sunday
SQL
0 vote95 views1 answer
Mysql date + 1 day
SQL
-1 vote149 views2 answers
Mysql get day of week
SQL
0 vote137 views1 answer
Data structures in sql
SQL
1 vote177 views1 answer
Postgresql if 0 then 1
SQL
0 vote135 views1 answer
Json_remove mysql
SQL
0 vote134 views1 answer
Mariadb number format
SQL