Querying the INFORMATION_SCHEMA

On March 3, 2008, in SQL, by Anuj Gakhar

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.

Tagged with:  

One Response to Querying the INFORMATION_SCHEMA

  1. Vanessa says:

    Well, what is that INFORMATION_SCHEMA is about? Is it a code that you can add on your main source code?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

© 2011 Anuj Gakhar
%d bloggers like this: