Querying the INFORMATION_SCHEMA

Tagged Under :

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.

Leave a Reply