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 vote284 views1 answer
Create procedure with encryption
SQL
7 votes249 views1 answer
Alter table add key sql
SQL
0 vote280 views1 answer
Sql find table by name
SQL
0 vote240 views1 answer
Check if due date is less than todays date sql
SQL
0 vote322 views1 answer
Change date format in oracle query
SQL
0 vote320 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote316 views1 answer
SQL check if record exist
SQL
0 vote322 views1 answer
Mysql edit trigger
SQL
22 votes295 views3 answers
SQL CHEATSHEET
SQL
0 vote291 views1 answer
Sqlite3 update select
SQL