DROP TABLE
Function
DROP TABLE is a DataArts Fabric SQL syntax used to delete a table with a specified name from LakeFormation.
Precautions
When a managed table is deleted, the metadata, statistics, and data of the table are also deleted. If the data volume is large, the statement execution may take a long time. When an external table is deleted, only the metadata and statistics of the table are deleted, but the data is not deleted.
Syntax
1
|
DROP TABLE [IF EXISTS] table_name; |
Parameter Description
- IF EXISTS
Reports a notice instead of an error if the specified table does not exist.
- table_name
Name of the LakeFormation table.
Examples
Delete the test_table table.
1
|
DROP TABLE test_table; |
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