/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 votes155 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote121 views1 answer
Update row in sqlite python
SQL
0 vote180 views1 answer
How to create a new db from dumb file mysql
SQL
10 votes120 views2 answers
Django mysql
SQL
6 votes188 views3 answers
What is where in sql
SQL
17 votes173 views2 answers
T_sql contains
SQL
1 vote170 views1 answer
Update and replace mysql
SQL
1 vote166 views3 answers
How to get date in sql
SQL
0 vote169 views2 answers
Disallowed function mysql to_date()
SQL
1 vote174 views1 answer
Retrieve meaning
SQL