Help Center> Data Warehouse Service (DWS)> Tool Guide (Paris Region)> Data Studio - Integrated Database Development Tool> GaussDB(DWS) Tables> Managing Table> Dropping a Table

Updated on 2022-07-29 GMT+08:00

View PDF

Dropping a Table

Individual or batch dropping can be performed on tables. Refer to Batch Dropping Objects section for batch dropping.

This operation removes the complete table structure (including the table definition and index information) from the database and you have to re-create this table once again to store data.

Follow the steps below to drop the table:

Right-click the selected table and select Drop Table.
Data Studio prompts you to confirm this operation.
In the confirmation dialog box, click OK to complete the operation successfully.
The status bar displays the status of the completed operation.

Parent topic: Managing Table

Previous topic: Setting the Schema

Next topic: Viewing Table Properties

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.See the reply and handling status in My Cloud VOC.

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

For any further questions, feel free to contact us through the chatbot.