/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 vote187 views1 answer
Luu ckeditor vao mysql
SQL
0 vote189 views1 answer
Sql find record cannot cast date
SQL
2 votes196 views1 answer
Oracle kill session by sql_id
SQL
0 vote169 views1 answer
Split a string with expression and get the last value of split sql
SQL
2 votes196 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
22 votes209 views3 answers
Year format in date mysql
SQL
0 vote185 views1 answer
T sql return on letters only
SQL
0 vote200 views1 answer
How to export only procedures mysql
SQL
0 vote188 views1 answer
Sql string length postgresql
SQL
1 vote192 views4 answers
Psql check tables command
SQL