DQL 学习2 -- DQL声明

将对象名和属性名用双引号括起来， 这样可以避免和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