Featured

    Featured Posts

  • Relation Between Games and Studies
  • Best Screen Protector for Nintendo Switch Available So Far
  • Gamer Problems: Then vs. Now [Comic]
  • Facebook Messenger May Soon Get Reactions, Dislike Button
  • What Happens When You Stop Smoking?

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


Post a Comment

www.CodeNirvana.in

Copyright © New Techie