I have always used INFORMATION_SCHEMA to some extent in some way or the other. Its quite handy to get information about database objects. This morning, I saw a nice article about this on SqlServerCentral. The author’s name is Mike and he does a pretty good job in explaining the concepts. There is also a stored procedure to search a specific value database-wide.
I recently found out that INFORMATION_SCHEMA is not only Sql Server specific (which is what I used to think). MySql supports this as well. Details here.
Well, what is that INFORMATION_SCHEMA is about? Is it a code that you can add on your main source code?