/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
Postgresql array to rows
SQL
1 vote164 views1 answer
Ora-01109 database not open in oracle 19c
SQL
1 vote155 views2 answers
Mysql add column tinyint default 0
SQL
2 votes151 views1 answer
Mysql cannot delete or update a parent row
SQL
3 votes135 views1 answer
Stpop start psql server
SQL
0 vote143 views3 answers
Magento 2 order delete from db
SQL
0 vote158 views1 answer
Influxdb list all tags for a measurement
SQL
5 votes155 views1 answer
Oracle columns in all_tables
SQL
8 votes135 views1 answer
Oracle create datafile
SQL
0 vote131 views1 answer
Sql developer search all packages for text
SQL