/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 vote204 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
24 votes207 views4 answers
Delete db postgres
SQL
1 vote165 views1 answer
Postgres killing connections on db
SQL
2 votes188 views1 answer
SQL column name Postgre
SQL
0 vote200 views1 answer
Oracle date summer time
SQL
0 vote172 views1 answer
Change date format in oracle query
SQL
0 vote173 views1 answer
Sql not exists
SQL
0 vote155 views1 answer
Count the table indatabase
SQL
0 vote186 views1 answer
Mysql check datetime equals date
SQL
2 votes200 views2 answers
Install postgresql
SQL