/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 vote192 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote160 views1 answer
What is initial catalog in sql connection string
SQL
0 vote159 views1 answer
Sql recherche nom prenom
SQL
0 vote143 views1 answer
Alter table fulltext
SQL
27 votes159 views5 answers
Add column in table
SQL
3 votes159 views2 answers
Oracle for loop
SQL
0 vote182 views1 answer
Sql developer sql worksheet not showing
SQL
1 vote144 views1 answer
Oracle rolling back
SQL
0 vote111 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
3 votes151 views4 answers
Show sql server database
SQL