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

  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.