thebentern/FindColumn.sql

Created December 24, 2015 13:44

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/thebentern/fc6646168e783bdf0844.js"></script>
Save thebentern/fc6646168e783bdf0844 to your computer and use it in GitHub Desktop.

Download ZIP

Find Column by name in Database

Raw

FindColumn.sql

	SELECT c.name AS ColName, t.name AS TableName
	FROM sys.columns c
	JOIN sys.tables t ON c.object_id = t.object_id
	WHERE c.name LIKE '%MyName%'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment