/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

5 votes262 views1 answer
How to get all table names in sql query
SQL
0 vote207 views1 answer
Rabbitmq ui not working
SQL
7 votes206 views2 answers
Oracle sql drop index
SQL
0 vote226 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
1 vote187 views1 answer
How much every mysql database record takes from diskspace
SQL
1 vote239 views2 answers
Login to mysql
SQL
1 vote204 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
1 vote205 views1 answer
Oracle create program if no exists
SQL
2 votes283 views1 answer
Brew start postgres manual
SQL
0 vote237 views1 answer
UNION ALL LEFT JOIN
SQL