SQLServerCentral / Discuss Content Posted by Sureshkumar Ramakrishnan / Article Discussions / Article Discussions by Author / Finding a particular column in All tables / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 18:23:47 GMT20RE: Finding a particular column in All tableshttp://www.sqlservercentral.com/Forums/Topic407960-198-1.aspx[quote][b]Kishore.P (11/6/2008)[/b][hr]try like: select *from INFORMATION_SCHEMA.COLUMNSwhere COLUMN_NAME = 'your column name'go[/quote]It would return View alsoFri, 07 Nov 2008 00:42:22 GMTMadhivanan-208264RE: Finding a particular column in All tableshttp://www.sqlservercentral.com/Forums/Topic407960-198-1.aspxtry like: select *from INFORMATION_SCHEMA.COLUMNSwhere COLUMN_NAME = 'your column name'goThu, 06 Nov 2008 06:39:31 GMTKishore.PRE: Finding a particular column in All tableshttp://www.sqlservercentral.com/Forums/Topic407960-198-1.aspxorselect object_name(object_id) as table_name from sys.columnswhere name='column_name' and objectproperty(object_id,'istable')=1Thu, 06 Nov 2008 06:22:22 GMTMadhivanan-208264Finding a particular column in All tableshttp://www.sqlservercentral.com/Forums/Topic407960-198-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL+Aids/31828/">Finding a particular column in All tables</A>[/B]Mon, 08 Oct 2007 06:51:50 GMTSureshkumar Ramakrishnan