ⓘ SQL/MED

                                     

ⓘ SQL/MED

The SQL/MED extension to the SQL standard is defined by ISO/IEC 9075-9:2008. SQL/MED provides extensions to SQL that define foreign-data wrappers and datalink types to allow SQL to manage external data. External data is data that is accessible to, but not managed by, an SQL-based DBMS. This standard can be used in the development of federated database systems.

                                     

1. Implementations

  • Teiid has support for SQL/MED.
  • Farrago has support for SQL/MED.
  • LucidDB has support for SQL/MED.
  • IBM DB2 has support for SQL/MED.
  • MariaDB has support for SQL/MED with the CONNECT storage engine. The implementation uses different syntax than the official standard.
  • PostgreSQL has support for some SQL/MED since version 9.1. 9.2 supports more.