advanced code snippet search

Posted By

CDIDevs on 12/31/09


Tagged

sql search mssql tsql for Microsoft column


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Tyster


Search Database for Column Name

 / Published in: SQL
 

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

Expand | Embed | Plain Text 
  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

Report this snippet  

You need to login to post a comment.