| title | DROP EXTERNAL TABLE (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/03/2017 | |
| ms.prod | sql-non-specified | |
| ms.prod_service | sql-data-warehouse, pdw, sql-database | |
| ms.service | ||
| ms.component | t-sql|statements | |
| ms.reviewer | ||
| ms.suite | sql | |
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | 02a6a236-0756-4570-abfa-6f677a7df042 | |
| caps.latest.revision | 12 | |
| author | barbkess | |
| ms.author | barbkess | |
| manager | craigg | |
| ms.workload | Inactive |
[!INCLUDEtsql-appliesto-ss2016-xxxx-asdw-pdw-md]
Removes a PolyBase external table from. This does not delete the external data.
Transact-SQL Syntax Conventions
DROP EXTERNAL TABLE [ database_name . [schema_name ] . | schema_name . ] table_name
[;]
[ database_name . [schema_name] . | schema_name . ] table_name
The one- to three-part name of the external table to remove. The table name can optionally include the schema, or the database and schema.
- Requires ALTER permission on the schema to which the table belongs.
Dropping an external table removes all table-related metadata. It does not delete the external data.
DROP EXTERNAL TABLE SalesPerson;
DROP EXTERNAL TABLE dbo.SalesPerson;
DROP EXTERNAL TABLE EasternDivision.dbo.SalesPerson;
The following example removes the ProductVendor1 table, its data, indexes, and any dependent views from the current database.
DROP EXTERNAL TABLE ProductVendor1;
The following example drops the SalesPerson table in the EasternDivision database.
DROP EXTERNAL TABLE EasternDivision.dbo.SalesPerson;