/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 vote229 views1 answer
How to use select union and loop
SQL
1 vote108 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
4 votes154 views5 answers
Get last query in codeigniter 4
SQL
2 votes120 views2 answers
Exec procedure pl sql
SQL
0 vote121 views1 answer
Sql server manager close connection
SQL
1 vote140 views1 answer
Oracle columns table
SQL
0 vote138 views1 answer
Disable database droping sql
SQL
0 vote125 views1 answer
Add sqlite3 in lumen
SQL
0 vote128 views1 answer
Display first three characters sql
SQL
0 vote126 views1 answer
Gcloud check sql
SQL