/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 vote216 views1 answer
T-sql check if data exists
SQL
0 vote219 views1 answer
Mysql filter based on datediff
SQL
0 vote201 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote231 views1 answer
How to print some string in mysql
SQL
0 vote221 views1 answer
Oracle current timestamp insert statement
SQL
1 vote224 views1 answer
Ubuntu access database from terminal
SQL
2 votes236 views1 answer
Pdo mysql insert
SQL
4 votes202 views1 answer
Update table from another table oracle
SQL
0 vote219 views1 answer
Mysql get last 2 month data
SQL
0 vote254 views1 answer
Wordpress make wp user in db
SQL