/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

4 votes390 views1 answer
Mysql query first character
SQL
3 votes366 views2 answers
To_char sql
SQL
1 vote363 views1 answer
How to test for sql injection
SQL
2 votes353 views1 answer
SQL IF ELSE
SQL
0 vote356 views1 answer
Sql on-premises
SQL
0 vote336 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote341 views1 answer
Mysql docker image arjun
SQL
0 vote356 views1 answer
List all indexes postgres
SQL
0 vote399 views1 answer
Drop a view in sqlite
SQL
0 vote367 views2 answers
Suse stop MySQL
SQL