Skip to content

Instantly share code, notes, and snippets.

@ddo

ddo/Find colum in all tables.sql

Created April 10, 2013 03:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ddo/5351633 to your computer and use it in GitHub Desktop.
Save ddo/5351633 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Find colum in all tables.sql
USE tlnmd
GO
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 = 'office_owner'
ORDER BY table_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment