/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

2 votes339 views2 answers
Mysql alter column default
SQL
0 vote293 views1 answer
Duplicate foreign key constraint name
SQL
0 vote355 views1 answer
Sql with example
SQL
11 votes340 views6 answers
Distinct sql
SQL
0 vote1.1K views1 answer
Mysql custom sort order
SQL
0 vote312 views1 answer
Install mysql 8 linux
SQL
1 vote333 views1 answer
Cross schema query oracle 2 users
SQL
1 vote309 views2 answers
Pl sql case
SQL
0 vote367 views1 answer
Psql check if sql script is valid
SQL
0 vote310 views1 answer
Change default schema sql server
SQL