This Sql query returns all the tables with the specified column name.
SELECT t.name FROM sys.tables t INNER JOIN sys.columns c ON c.object_id = t.object_id WHERE c.name ='ColumnName' ORDER BY t.name asc
edit | flag
Gokul A Answered on: Jun 16, 2011 at 10:58PM
Post your Answer
Welcome to Ask Amoeba! This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions. Learners, beginners, Experts stop and share your knowledge and ideas!