将对象名和属性名用双引号括起来, 这样可以避免和DQL的保留值和数据库的保留字发生命名冲突。
Abort
ABORT [TRAN[SACTION]]
Alter Group
ALTER GROUP group_name ADD members
ALTER GROUP group_name DROP members
ALTER GROUP group_name SET ADDRESS email_address
ALTER GROUP group_name SET PRIVATE TRUE/FALSE
Alter Aspect
ALTER ASPECT aspect_name ADD_FTINDEX ALL
ALTER ASPECT aspect_name DROP_FTINDEX ALL
ALTER ASPECT aspect_name ADD_FTINDEX property_list
ALTER ASPECT aspect_name DROP_FTINDEX property_list
Alter Type
ALTER TYPE type_name ADD property_def {,property_def }
...............................
Begin Tran
BEGIN TRAN[SACTION]
Change.. Object
CHANGE current_type [(ALL)]OBJECT[S]
TO new_type [ update_list ]
[INASSEMBLY document_id [VERSION version_label ][DESCEND]]
[SEARCH fulltextsearchcondition ]
[WHERE qualification ]
Commit
COMMIT [TRAN[SACTION]]
Create Group
CREATE [PUBLIC|PRIVATE] GROUP group_name [WITH] [ADDRESS email_address] [MEMBERS members];
Create .. Object
CREATE type_name OBJECT update_list
[,SETFILE' filepath 'WITHCONTENT_FORMAT=' format_name ']
{,SETFILE' filepath 'WITHPAGE_NO= page_number }
Create Type
CREATETYPE type_name
[( property_def {, property_def })]
[WITH]SUPERTYPE parent_type
[ type_modifier_list ][PUBLISH]
To create a partitionable type:
CREATEPARTITIONABLETYPE type_name
[( property_def {, property_def })]
[WITH]SUPERTYPENULL
[ type_modifier_list ][PUBLISH]
To create a shareable type:
CREATESHAREABLETYPE type_name
[( property_def {, property_def })]
[WITH]SUPERTYPE parent_type [PUBLISH]
To create a lightweight type:
CREATELIGHTWEIGHTTYPE type_name
[( property_def {, property_def })]
SHARES shareable_type
[AUTOMATERIALIZATION|
MATERIALIZATIONONREQUEST|
DISALLOWMATERIALIZATION]
[FULLTEXTSUPPORT[
NONE|
LITEADDALL
LITEADD property_list |
BASEADDALL|
BASEADD property_list
]
[PUBLISH]
Delete
DELETE FROM table_name WHERE qualification
Delete ... Object
DELETE[PUBLIC] type_name [(ALL)]
[ correlation_variable ]
[WITHINPARTITION( partition_id {, partition_id })
OBJECT[S]
[INASSEMBLY document_id [VERSION version_label ]
[NODE component_id ][DESCEND]]
[SEARCH fulltextsearchcondition ]
[WHERE qualification ]
DROP Group
DROP GROUP group_name
DROP Type
DROP TYPE type_name
Execute
EXECUTE admin_method_name [[FOR] object_id ]
[WITH argument = value {, argument = value }]
Grant
GRANT privilege {,privilege} To users
Insert
INSERTINTO table_name [( column_name {, column_name })]
VALUES( value {, value })| dql_subselect
Register
REGISTERTABLE[ owner_name .] table_name
( column_def {, column_def })
[[WITH]KEY( column_list )]
[SYNONYM[FOR]' table_identification ']
Revoke
REVOKE privilege {,privilege} FROM users;
Select