/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

15 votes211 views3 answers
Postgresql change column type
SQL
5 votes220 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
0 vote216 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote224 views1 answer
How to get nth number in sql
SQL
8 votes222 views1 answer
Oracle search stored procedures for text
SQL
1 vote209 views1 answer
Oracle drop chain step
SQL
0 vote195 views1 answer
Setting default value for Boolean data type in SQL
SQL
1 vote209 views1 answer
Change old domain to new domain name wordpress
SQL
1 vote203 views2 answers
Sql drop multiple columns if exists
SQL
1 vote221 views1 answer
Last 24 HOUR data in mysql
SQL