/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

38 votes359 views6 answers
Ubuntu install mysql client
SQL
0 vote238 views1 answer
Big query add table rows to another table
SQL
4 votes273 views1 answer
Mysql timestamp in laravel migration
SQL
9 votes278 views4 answers
SQL Date Format
SQL
1 vote275 views2 answers
Sql now - 1 day
SQL
12 votes278 views1 answer
Script to add new column in table sql
SQL
3 votes271 views1 answer
Oracle revoke
SQL
1 vote280 views1 answer
How to remove identity from a column in sql server
SQL
11 votes299 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote283 views1 answer
Mariadb search columns
SQL