Advanced Search

Search Database for Column Name

/ Published in: SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. /*
  2. Date:			2009-12-08
  3. Resource URL:		http://snippets.dzone.com/posts/show/2035
  4. Purpose:		Search DB for column name 
  5. */ 
  6.  
  7. SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name LIKE 'productid%' ) ORDER BY name

URL: http://snippets.dzone.com/posts/show/2035

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.