XML RSS feed Articles » INFORMATION_SCHEMA

Updated articles to extract META informations from databases

By popular request, I've updated my articles explaining how to retrieve meta data from your DBMS (Firebird SQL, PostgreSQL, Oracle, SQL Server). Have fun.

Extracting META information from Interbase/Firebird SQL (INFORMATION_SCHEMA)

Extracting META informations from Interbase/Firebird System Tables (INFORMATION_SCHEMA)

Extracting META information from Oracle (INFORMATION_SCHEMA)

Extracting META information from an Oracle database using the Oracle Data Dictionary views (INFORMATION_SCHEMA)

Extracting META information from SQL Server (INFORMATION_SCHEMA)

How to retrieve META information from Microsoft SQL Server, using the INFORMATION_SCHEMA, with system tables (sysobjects, sysindexkeys, sysindexes, syscolumns, systypes, etc) and/or with system stored procedures (T-SQL).

Extracting META information from PostgreSQL (INFORMATION_SCHEMA)

Extracting META information from a PostgreSQL database using the INFORMATION_SCHEMA views and the system catalogs (pg_class, pg_user, pg_view)

Lorenzo Alberton

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