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 vote363 views1 answer
How to query without duplicate rows in sql
SQL
17 votes372 views6 answers
What is cursor in sql server with example
SQL
0 vote351 views1 answer
Access mysql database docker container shell
SQL
0 vote355 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote352 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
0 vote387 views1 answer
Oracle concat datetime
SQL
0 vote338 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
2 votes374 views1 answer
Revokeprivileges mysql
SQL
0 vote357 views2 answers
Alter table add multiple columns mysql
SQL
0 vote353 views1 answer
Sql create text column limited values
SQL