Skip to content

Sceurpien

Personal page of Sceurpien
  • Home
  • About Me
  • Database Optimalization
  • Programming stuff

Tag: sys.tables

Search column name in tables

June 17, 2018 Sceurpien 6d Comments

This code is something I used frequently, when I started to work with an old legacy database, with more, than 400 tables.

SELECT		
	c.name  AS 'ColumnName'
	,t.name AS 'TableName'
FROM		
	sys.columns c
INNER JOIN	
	sys.tables  t   
	ON 
		c.object_id = t.object_id
WHERE		
	c.name LIKE '%Column Name%'
ORDER BY	
	TableName, ColumnName
Posted in: sql search Filed under: column, object_id, search, sql, sys.columns, sys.tables, table

Recent Posts

  • Table connection in GraphForm
  • Search for a specific value in any column
  • Search for a specific value in a common named column

Recent Comments

  • Clyde Volkova on Search column name in tables
  • Caroline Gallagher on Search column name in tables
  • buy cialis on Search column name in tables

Archives

  • January 2019
  • August 2018
  • July 2018
  • June 2018

Contact Us

  • Email
    sceurpien@gmail.com
  • Home
  • About Me
  • Database Optimalization
  • Programming stuff
Copyright © 2018 Sceurpien — Escapade WordPress theme by GoDaddy