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 vote287 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote280 views1 answer
Sql datediff db2
SQL
1 vote234 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote264 views1 answer
Oracle flush Shared Pool
SQL
1 vote265 views1 answer
Using SQL in rails migration
SQL
1 vote296 views1 answer
T-sql find object by name
SQL
0 vote283 views1 answer
Sql dmv to capture updates
SQL
20 votes331 views4 answers
Sql count if
SQL
22 votes310 views3 answers
How to join three tables in sql using joins
SQL
2 votes280 views1 answer
Sql to char function with date
SQL