DROP EXTERNAL TABLE (Transact-SQL)
Applies to:
SQL Server 2016 (13.x) and later
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
Removes a PolyBase external table from a database, but doesn't delete the external data.
Transact-SQL syntax conventions
Syntax
DROP EXTERNAL TABLE { database_name.schema_name.table_name | schema_name.table_name | table_name }
[;]
Arguments
[ 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.
Permissions
Requires:
- ALTER permission on the schema to which the table belongs.
- ALTER ANY EXTERNAL DATA SOURCE
- ALTER ANY EXTERNAL FILE FORMAT
Remarks
Dropping an external table removes all table-related metadata. It doesn't delete the external data.
Examples
A. Using basic syntax
DROP EXTERNAL TABLE SalesPerson;
DROP EXTERNAL TABLE dbo.SalesPerson;
DROP EXTERNAL TABLE EasternDivision.dbo.SalesPerson;
B. Dropping an external table from the current database
The following example removes the ProductVendor1
table, its data, indexes, and any dependent views from the current database.
DROP EXTERNAL TABLE ProductVendor1;
C. Dropping a table from another database
The following example drops the SalesPerson
table in the EasternDivision
database.
DROP EXTERNAL TABLE EasternDivision.dbo.SalesPerson;
See Also
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें