In this post, we want to discuss about all tables containing column with specified name in SQL Server. Before we get started, if you want to know necessity of Store Procedure, please go through the following article: Why do we need use Stored Procedure?

Say the column name is “MyColumnName”. The SQL is as bellow

For searching in Tables and View in same DB

all tables containing column sql server

Leave a Reply

2 Comments

  • Hiya very cool site!! Man .. Beautiful .. Amazing .. I’ll bookmark your website and take the feeds also? I am satisfied to seek out a lot of useful information right here in the put up, we need work out extra techniques on this regard, thank you for sharing. . . . . .|