/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 vote108 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote137 views1 answer
Postgres docs /copy metacomand
SQL
0 vote115 views2 answers
Execute stored procedure without db set
SQL
1 vote108 views1 answer
Alter add syntax
SQL
0 vote110 views1 answer
SQL authentication error
SQL
0 vote120 views1 answer
Find and replace database table phpmyadmin
SQL
2 votes120 views3 answers
Mysql list tables by size
SQL
7 votes133 views2 answers
How to create index mysql
SQL
0 vote109 views1 answer
Sql convert float to string
SQL
0 vote116 views1 answer
Sql select most frequent value in group
SQL