/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 vote143 views1 answer
Delete a record from a table sqlite3
SQL
0 vote156 views1 answer
How to find unique element in sql
SQL
0 vote131 views1 answer
Mysql cli output to a file
SQL
2 votes128 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
4 votes154 views2 answers
Dbms output
SQL
0 vote142 views1 answer
Mysql row generator
SQL
0 vote138 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote131 views1 answer
Logtash mysql cofiguration file
SQL
3 votes149 views1 answer
Oracle function return
SQL
1 vote130 views3 answers
Mysql Server Start
SQL