Help Center/ Distributed Database Middleware/ User Guide/ SQL Syntax/ Supported SQL Statements/ TRUNCATE TABLE/ HINT-TABLE
Updated on 2022-09-16 GMT+08:00
HINT-TABLE
Command Format:
/*+table=<physical_table_name>*/ TRUNCATE TABLE <table_name>
Description:
Deleting data in physical table <physical_table_name> in the current database shard does not affect other physical tables.
Example output before the table is deleted:

Example output after the table is deleted:

Parent topic: TRUNCATE TABLE
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.