/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

11 votes154 views2 answers
Turn off safe mode mysql
SQL
0 vote175 views1 answer
Best sql collation
SQL
0 vote147 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote148 views1 answer
Drop tables from local database postgres pgadmin
SQL
4 votes150 views1 answer
Postgres delete last row
SQL
0 vote142 views2 answers
Mysql two column combination unique
SQL
1 vote148 views1 answer
Update from select join
SQL
0 vote147 views1 answer
Difference between varchar and varchar2
SQL
41 votes233 views6 answers
Alter table add column in SQL Server
SQL
0 vote156 views1 answer
Import mysql'
SQL