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

5 votes728 views1 answer
Oracle ora-00054 find
SQL
6 votes139 views2 answers
How to copy data in sql
SQL
0 vote146 views1 answer
Postgresql like
SQL
0 vote151 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote187 views1 answer
DATEDIFF minute postgres
SQL
1 vote145 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
1 vote171 views1 answer
Sql and
SQL
0 vote150 views1 answer
Postgres statistics
SQL
6 votes150 views2 answers
Mysql check auto increment value
SQL
0 vote146 views1 answer
Split string by comma in sql server
SQL