The following limitations apply to TDS foreign data wrapper:
- TDS foreign data wrapper doesn't currently support
JOINpushdown. - TDS foreign data wrapper doesn't currently support write operations (
INSERT,UPDATE,DELETE). - The
CREATE FOREIGN TABLEoptionrow_estimate_methodsupports valueshowplan_allonly with Microsoft SQL Server. It isn't available for Sybase databases.