DROP FOREIGN TABLE
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
1 2 |
DROP FOREIGN TABLE [ IF EXISTS ] table_name [, ...] [ CASCADE | RESTRICT ]; |
Parameter Description
Parameter |
Description |
Value Range |
---|---|---|
IF EXISTS |
Sends a message instead of an error if the specified foreign table does not exist. |
- |
table_name |
Specifies the name of the foreign table to be deleted. |
An existing table name. |
CASCADE | RESTRICT |
Specifies how to process related data in the dependent object when a delete operation is performed. |
|
Examples
Delete the foreign table named customer_ft:
1
|
DROP FOREIGN TABLE customer_ft; |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot