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 vote288 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote274 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote303 views1 answer
Mysql bash execute sql file
SQL
2 votes249 views2 answers
Select multiple tables mysql
SQL
0 vote279 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote271 views1 answer
Insert array into mysql column
SQL
-2 votes264 views3 answers
Oracle tablespace usage
SQL
1 vote270 views1 answer
Mysql f# examples
SQL
8 votes271 views3 answers
Postgres connection string
SQL
0 vote271 views1 answer
Select last N rows mysql
SQL