/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

0 vote297 views1 answer
Query by column for substring sql
SQL
0 vote279 views1 answer
Joins vs includes
SQL
-1 vote282 views1 answer
Adding a new table psql
SQL
0 vote281 views1 answer
Console output pl sql
SQL
0 vote306 views1 answer
Compare subqueries oracle
SQL
0 vote273 views1 answer
C# select Mysql
SQL
0 vote267 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL
1 vote282 views1 answer
Psql lst trigger
SQL
0 vote292 views1 answer
Mysql subtract month from timestamp
SQL
3 votes301 views2 answers
Update Query in SQL Server
SQL