The SQL 2003 Standard introduced a schema called INFORMATION_SCHEMA.

This story continues at http://www.databasejournal.com/news/article.php/3602511