Posted By

CDIDevs on 12/31/09


sql search mssql tsql for Microsoft column

Versions (?)

Who likes this?

1 person have marked this snippet as a favorite


Search Database for Column Name

 / Published in: SQL


  1. /*
  2. Date: 2009-12-08
  3. Resource URL:
  4. Purpose: Search DB for column name
  5. */
  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.