/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

14 votes111 views2 answers
How to auto increment in sql
SQL
11 votes124 views5 answers
Sql server reset identity
SQL
0 vote115 views1 answer
Mysql to get column name in database
SQL
0 vote122 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote119 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote130 views1 answer
Sql filter rows with condition
SQL
1 vote113 views1 answer
Sql order by where condition
SQL
0 vote130 views2 answers
Unique key
SQL
5 votes108 views2 answers
Oracle show procedures
SQL
0 vote108 views1 answer
Sql server manager close connection
SQL