/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 vote238 views1 answer
Epoch time converter in snowflake
SQL
0 vote156 views1 answer
Microsoft sql server management studio clear cache
SQL
0 vote206 views1 answer
Mssql current date
SQL
1 vote223 views1 answer
Mysql order by desc null last
SQL
0 vote213 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
0 vote205 views2 answers
Default constraint in ms sql
SQL
12 votes204 views2 answers
Delete entries in postgresql
SQL
0 vote248 views1 answer
Postgresql import data from csv
SQL
0 vote205 views1 answer
Insert array into mysql column
SQL
5 votes218 views1 answer
Oracle drop index if exists
SQL