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

1 vote217 views1 answer
Oracle sql pad left zeros
SQL
0 vote202 views1 answer
Why we have to set the password for my sql server
SQL
1 vote220 views1 answer
Oracle split string
SQL
2 votes205 views1 answer
Mysql set value as null
SQL
1 vote239 views2 answers
Install sql server management studio ubuntu
SQL
6 votes207 views2 answers
Postgresql database url
SQL
21 votes219 views4 answers
Add column mssql
SQL
12 votes192 views2 answers
Delete all data in neo4j
SQL
1 vote203 views1 answer
Mysql show table character set
SQL
1 vote194 views1 answer
Delete triger pl pg sql
SQL