HomeMogDBMogDB StackUqbar
v5.0

Documentation:v5.0

Supported Versions:

Other Versions:

AST

Function

Verifies the MogDB syntax tree.

Checks whether the statements following the AST syntax support the generation of the MogDB syntax tree.

Precautions

If the verification fails, a syntax parsing error is thrown. If the verification is successful, no command output is displayed.

Syntax

AST [ STMT ] ;

Parameter Description

  • STMT

Any type of SQL statements and stored procedure statements are supported.

Examples

-- Verify table creation statements.
MogDB=# AST CREATE TABLE TEST(ID INT6);

-- Statement verification is not supported.
MogDB=# AST CREATE TABLE TEST;
ERRPR: syntax error at or near ";"
LINE 1:AST CREATE TABLE TEST;
                            ^ 
Copyright © 2011-2024 www.enmotech.com All rights reserved.