Skip to content

Instantly share code, notes, and snippets.

@DylanKnevitt

DylanKnevitt/GetColumnAndTableByName

Last active August 29, 2015 14:06
Show Gist options
  • Save DylanKnevitt/05de08b23bd5e5265fec to your computer and use it in GitHub Desktop.
Save DylanKnevitt/05de08b23bd5e5265fec to your computer and use it in GitHub Desktop.
Download ZIP
Get Column and Table by name
Raw
GetColumnAndTableByName
SELECT * FROM sys.tables st
INNER JOIN sys.columns sc on sc.object_id = st.object_id
WHERE
sc.name = '' and st.name = ''
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment