How I find a particular column name within all tables of SQL database.

Most of the time, we have to find such a column from the whole database. The solution is provided below:



For example: I have a database named Employee, I have more than one table where employee_id column is present.

Here I am searching for column_name which contains employee_id within its name. It will return all the tables and respective columns containing employee_id



    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

 
Copyright © 2013. New Techie - All Rights Reserved
Template Created by ThemeXpose