/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 vote285 views1 answer
Mysql date time string format python
SQL
0 vote424 views1 answer
Sql developer export connections
SQL
62 votes409 views8 answers
Mysql add column
SQL
0 vote296 views1 answer
How to execute stored output to csv files
SQL
0 vote277 views1 answer
Changer un mot de passe mysql
SQL
3 votes319 views2 answers
Mysql update row
SQL
1 vote281 views1 answer
Temp table vs variable table in sql server
SQL
0 vote337 views1 answer
How to convert external table to managed table in hive
SQL
0 vote242 views1 answer
Sql count how many times a value appears
SQL
0 vote289 views1 answer
Import sql inside hide sql
SQL