The post gives a common useful SQL statement that finding a column name in databases. I always looking for it again and again, so I decided on to put this statement into the blog. The example below is to find a column with characters like “move_kin”.
SELECT c.name AS ColName, t.name AS TableName FROM
JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE