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 vote138 views1 answer
Restore backupfile discourse
SQL
1 vote146 views1 answer
Mysql backup skip table
SQL
2 votes133 views2 answers
Compare date mysql
SQL
0 vote183 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote206 views1 answer
How to rename a database in tsql
SQL
0 vote148 views1 answer
Sql remove last 2 digit
SQL
4 votes138 views4 answers
What is primary key
SQL
14 votes143 views3 answers
Trim sql
SQL
4 votes167 views1 answer
Postgresql create table with index
SQL
25 votes145 views6 answers
Sql update query
SQL