# SQL/MED

> Mediated Wiki article. Canonical URL: https://mediated.wiki/source/SQL/MED
> Markdown URL: https://mediated.wiki/source/SQL/MED.md
> Source: https://en.wikipedia.org/wiki/SQL%2FMED
> Source revision: 1305275707
> License: Creative Commons Attribution-ShareAlike 4.0 International (https://creativecommons.org/licenses/by-sa/4.0/)

The **SQL/MED** ("Management of External Data") extension to the [SQL](/source/SQL) standard is defined by [ISO](/source/International_Organization_for_Standardization)/IEC 9075-9:2008 (originally defined for SQL:2003). SQL/MED provides extensions to SQL that define foreign-data wrappers and datalink types to allow SQL to manage external [data](/source/Data). External data is data that is accessible to, but not managed by, an SQL-based [DBMS](/source/DBMS). This standard can be used in the development of [federated database systems](/source/Federated_database_system).

## Implementations

- [PostgreSQL](/source/PostgreSQL) has support for some SQL/MED since version 9.1.[1][2]
- [LucidDB](/source/LucidDB) has support for SQL/MED.[3]
- [MariaDB](/source/MariaDB) has support for SQL/MED with the CONNECT storage engine.[4] The implementation uses different syntax than the official standard.
- [Farrago](/source/Farrago_(software)) has support for SQL/MED.[5]
- [IBM Db2](/source/IBM_Db2) has support for SQL/MED.[6]
- [Teiid](/source/JBoss_Developer_Studio#Features) has support for SQL/MED. [7]
- [Microsoft SQL Server](/source/Microsoft_SQL_Server) has internal support for SQL/MED. DATALINK is provided by the FILESTREAM[8] (SQL Server 2008) and FileTable (SQL Server 2012) functionnalities and external data wrapper by the EXTERNAL TABLEs and PolyBase[9]

## See also

- [SQL](/source/SQL)

## References

1. [PostgreSQL Wiki: SQL/MED](http://wiki.postgresql.org/wiki/SQL/MED)

1. [Chapter 5.12, "Foreign Data" of the PostgreSQL Guide](https://www.postgresql.org/docs/current/ddl-foreign-data.html).

1. [LucidDB Architecture](http://www.luciddb.org/html/arch.html)

1. [CONNECT storage engine](https://mariadb.com/kb/en/connect/)

1. [Farrago SQL/MED Support](https://farrago.sourceforge.net/design/sqlmed.html)

1. [IBM federated database technology](http://www.ibm.com/developerworks/data/library/techarticle/0203haas/0203haas.html)

1. [Teiid Documentation](https://github.com/teiid/teiid-documents/blob/master/reference/ddl_deployment_mode.adoc)

1. [FILESTREAM](https://learn.microsoft.com/en-us/sql/relational-databases/blob/filestream-sql-server)

1. [EXTERNAL TABLE / PolyBase](https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql)

## External links

- [SQL/MED - A Status Report](https://sigmodrecord.org/publications/sigmodRecord/0209/jimmelton.pdf)

---
Adapted from the Wikipedia article [SQL/MED](https://en.wikipedia.org/wiki/SQL%2FMED) by Wikipedia contributors ([contributor history](https://en.wikipedia.org/wiki/SQL%2FMED?action=history)). Available under [Creative Commons Attribution-ShareAlike 4.0 International](https://creativecommons.org/licenses/by-sa/4.0/). Changes may have been made.