Skip to content

Instantly share code, notes, and snippets.

@tahaipek
Created March 11, 2016 15:46
Show Gist options
  • Save tahaipek/d6de750e1450a06ef9f8 to your computer and use it in GitHub Desktop.
Save tahaipek/d6de750e1450a06ef9f8 to your computer and use it in GitHub Desktop.
MSSQL Find Column Name
USE [TESTDB]
GO
DECLARE @findColumn varchar(30) = '%Test%';
SELECT t.name AS table_name,
SCHEMA_NAME(schema_id) AS schema_name,
c.name AS column_name
FROM sys.tables AS t
INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID
WHERE c.name LIKE @findColumn
ORDER BY schema_name, table_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment