Updated articles to extract META informations from databases

It looks like my articles on how to extract META information from your favorite DBMS (with INFORMATION_SCHEMA or system tables) are still very popular, and I keep receiving a lot of mails on how to write similar queries to retrieve some obscure details about constraints, indices, stored procedures, etc.

For the greater good of mankind, and to reduce the flow of emails to my Inbox a bit ;-), I updated the articles and included new queries:

Enjoy!




Lorenzo Alberton

Lorenzo Alberton Lorenzo PHP5 ZCE - Zend Certified Engineer has been working with large enterprise UK companies for the past years and is now CTO at DataSift. He's an international conference speaker and a long-time contributor to many open source projects. Lorenzo Alberton's profile on LinkedIN View Lorenzo Alberton's Twitter stream

Lorenzo Alberton - Sun Certified MySQL 5 Developer

Tags

AJAX, Apache, Book Review, Charset, Cheat Sheet, Data structures, Database, Firebird SQL, Hadoop, Imagick, INFORMATION_SCHEMA, JavaScript, Kafka, Linux, Message Queues, mod_rewrite, Monitoring, MySQL, NoSQL, Oracle, PDO, PEAR, Performance, PHP, PostgreSQL, Profiling, Scalability, Security, SPL, SQL Server, SQLite, Testing, Tutorial, TYPO3, Windows, Zend Framework

Buy me a book - The Art Of Project Management