Sql find column name like

-- tables:
SELECT      c.name  AS 'ColumnName'
            ,t.name AS 'TableName'
FROM        sys.columns c
JOIN        sys.tables  t   ON c.object_id = t.object_id
WHERE       c.name LIKE '%MyName%'
ORDER BY    TableName
            ,ColumnName;
            
-- tables and views:
SELECT      COLUMN_NAME AS 'ColumnName'
            ,TABLE_NAME AS  'TableName'
FROM        INFORMATION_SCHEMA.COLUMNS
WHERE       COLUMN_NAME LIKE '%MyName%'
ORDER BY    TableName
            ,ColumnName;

Source: stackoverflow.com

Similar codes

0 vote162 views1 answer
Sqlalchemy get schema from database
SQL
1 vote143 views1 answer
Media sql
SQL
1 vote161 views1 answer
Mysql connect bash
SQL
1 vote182 views2 answers
Mysql add column tinyint default 0
SQL
13 votes159 views3 answers
Insert mysql ifile nto database
SQL
7 votes152 views3 answers
Postgre describe table
SQL
1 vote176 views1 answer
How do you use sql in you company
SQL
3 votes147 views1 answer
Créer une table sql
SQL
0 vote206 views1 answer
DATEDIFF minute postgres
SQL
1 vote139 views1 answer
Use of now() in mysql
SQL