Other Syntax List
In addition to DCL, DDL, and DML syntax, GaussDB also provides syntax for other functions.
Shutting Down The Current Node
GaussDB allows users to run the shutdown command to shut down the current database node. For details, see SHUTDOWN.
SQL Statements Related to Bucket Scale-out
GaussDB supports statements used by the scale-out tool to notify the kernel of the buckets that have been migrated. For details, see MARK BUCKETS.
Clearing Database Connections
GaussDB supports statements for clearing database connections. For details, see CLEAN CONNECTION.
Showing an Execution Plan of an SQL Statement
GaussDB provides statements for showing an execution plan of an SQL statement. For details, see EXPLAIN.
Storage Execution Plan
GaussDB provides statements for storing query execution plan information in the PLAN_TABLE table. For details, see EXPLAIN PLAN.
Prediction:
GaussDB provides statements for using a trained model to perform inference tasks. For details, see PREDICT BY.
Creating a Prepared Statement
GaussDB provides statements for creating a prepared statement. For details, see PREPARE.
SQL Statements Related to Transactions
Function |
SQL Statement |
---|---|
Rolling back the current transaction and canceling the changes in the transaction |
|
Starting a transaction |
|
Setting transaction log checkpoints |
|
Committing the current transaction |
|
Committing a prepared two-phase transaction |
|
Preparing the current transaction for two-phase commit |
|
Deleting a savepoint previously defined for the current transaction |
|
Canceling a transaction ready for two-phase commit |
|
Rolling back to a savepoint |
|
Creating a savepoint in the current transaction |
|
Setting constraint check timing for the current transaction |
Modifying, Displaying, and Restoring a Runtime Parameter
Setting a User Identifier
Function |
SQL Statement |
---|---|
Setting the current user identifier of the current session |
|
Setting the session user identifier and the current user identifier of the current session to a specified user |
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