DROP FOREIGN TABLE

Updated on 2024-12-19 GMT+08:00

View PDF

Function

DROP FOREIGN TABLE deletes a specified foreign table.

Precautions

DROP FOREIGN TABLE forcibly deletes a specified table. After a table is deleted, any indexes that exist for the table will be deleted. The functions and stored procedures used in this table cannot be run.

Syntax

    
       DROP FOREIGN TABLE [ IF EXISTS ] 
    table_name [, ...] [ CASCADE | RESTRICT ];

Parameter Description

IF EXISTS
Sends a notice instead of an error if the specified table does not exist.
table_name
Specifies the name of the foreign table to be deleted.

Value range: An existing table name.
CASCADE | RESTRICT
- CASCADE: automatically deletes all objects (such as views) that depend on the foreign table to be deleted.
- RESTRICT: refuses to delete the foreign table if any objects depend on it. This is the default behaviour.

Examples

Delete the foreign table named customer_ft:

    
       DROP FOREIGN TABLE customer_ft;

Helpful Links

ALTER FOREIGN TABLE (GDS Import and Export), ALTER FOREIGN TABLE (for HDFS or OBS), CREATE FOREIGN TABLE (for GDS Import and Export), CREATE FOREIGN TABLE (SQL on OBS or Hadoop)

Parent topic: DDL Syntax

Previous topic: DROP DATABASE

Next topic: DROP FUNCTION

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel