/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 vote346 views1 answer
Python mysql executemany
SQL
1 vote420 views1 answer
How to set up a trigger in sql
SQL
0 vote368 views1 answer
Product of a column in mysql
SQL
0 vote371 views1 answer
Postgresql port 5432 not open
SQL
0 vote347 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote348 views1 answer
How to change the field size of an existing column
SQL
18 votes355 views3 answers
Mysql query add column with default string value
SQL
0 vote316 views0 answer
SQL
0 vote398 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote335 views1 answer
Postgresql update to unique
SQL