/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 vote321 views1 answer
Mysql shell ERROR: Not connected.
SQL
1 vote300 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
10 votes286 views2 answers
Sql where clause multiple values
SQL
0 vote293 views1 answer
Get all employees if name ends with in sql
SQL
1 vote303 views1 answer
Stop mysql server mac
SQL
0 vote316 views1 answer
Ran rails db:migrate and got == 20210620104415 DeviseCreateUsers: migrating ================================ -- create_table(:users) rails aborted! StandardError: An error has occurred, this and all later migrations canceled: SQLite3::SQLE
SQL
0 vote321 views1 answer
Mariadb select limit offset
SQL
3 votes336 views2 answers
Sql not contains
SQL
5 votes327 views1 answer
How to get all dates in a month in oracle
SQL
0 vote285 views1 answer
Create dabase postgresql
SQL