Useful! Find a table from a column name
SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name like '%PART_OF_NAME%' )
From: http://snippets.dzone.com/posts/show/2035
Tags: column, SQL, syscolumns, sysobjects, table
SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name like '%PART_OF_NAME%' )
From: http://snippets.dzone.com/posts/show/2035
Tags: column, SQL, syscolumns, sysobjects, table
