Catalog of DDL command nodes

[This is preliminary documentation and subject to change.]

Node DBTREEVALUE R O Children Output
type
alteracharacteraset pwszValue 0 1 OPT 1: renameaobject
alteracollation pwszValue 0 1 OPT 1: renameaobject
alteradomain pwszValue 0 1 OPT 1: renameaobject
alteraindex pwszValue 0 1 OPT 1: renameaobject
alteraprocedure pwszValue 0 1 OPT 1: renameaobject
alteraschema pwszValue 0 1 OPT 1: renameaobject
alteratable pwszValue 0 1 OPT 1: renameaobject
alteratrigger pwszValue 0 1 OPT 1: renameaobject
alteraview pwszValue 0 1 OPT 1: renameaobject
characterasetaname pwszValue 0 0
coldefalistaanchor DBVALUEKINDa
EMPTY		 0 1 OPT 1: coldefalistaelement
coldefalistaelement DBVALUEKINDa
COLDESC		 0 1 OPT 1: propertyalistaanchor1,
propertyalistaelement: DBaPROPERTYa
DEFAULTaVALUE
DBaPROPERTYa
DESCRIPTION
DBaPROPERTYa
NULLABLE
DBPROPaUNIQUE
DBPROPa
PRIMARYKEY
DBPROPa
AUTOINCREMENT
createaassertion pwszValue 1 1 REQ 1: select

OPT 2: propertyalistaanchor,
propertyalistaelement:
DBaPROPERTYaCONSTRAINTaCHECKaDEFERRED,
DBaPROPERTYa
DESCRIPTION
createacharacteraset pwszValue 1 2 REQ 1: characterasetaname

OPT 1: collateaclause

OPT 2: propertyalistaanchor,
propertyalistaelement:
DBaPROPERTYa
DESCRIPTION
createacollation pwszValue 2 1 REQ 1: characterasetaname

REQ 2: TBD

OPT 1: TBD
createadomain pwszValue 1 3 REQ: dataatype

OPT 1: propertyalistaanchor,
propertyalistaelement:
DBaPROPERTYa
DEFAULTaVALUE

OPT 2: domainaconstraint

OPT 3: collateaclause
createaindex pwszValue 2 1 REQ 1: name (table name)REQ 2: columnalistaanchor,
columnalistaelement

The column list elements contain the name of a column and a sort order (ascending or descending).

OPT 1: propertyalistaanchor,
propertyalistaelement:
DBPROPaINDEXa
PRIMARYKEY

DBPROPaINDEXa
UNIQUE

DBPROPaINDEXa
CLUSTERED

DBPROPaINDEXa
TYPE

DBPROPaINDEXa
FILLFACTOR

DBPROPaINDEXa
INITIALSIZE

DBPROPaINDEXa
NULLS

DBPROPaINDEXa
SORTBOOKMARKS

DBPROPaINDEXa
AUTOUPDATE

DBPROPaINDEXa
NULLCOLLATION
createaprocedure pwszValue TBD TBD TBD
createaschema DBVALUEKINDa
EMPTY		 0 3 OPT 1: schemaaauthorization

OPT 2: schemaaname

OPT 3: propertyalistaanchor,
propertyalistaelement:
DBaPROPERTYa
DESCRIPTION
create_synonym pwszValue
(local name for synonym)		 1 1 REQ 1: table_name

OPT 1: property_list_anchor,
property_list_element:
DBINIT_OPT_
CLSID,
DBINIT_OPT_
MONIKER
DBINIT_OPT_
LOCATION
DBINIT_OPT_
NAME
DBINIT_OPT_
USERID,
DBINIT_OPT_
PASSWORD
DBINIT_OPT_
STRING
create_table pwszValue 1 5 REQ 1: coldef_list_anchor


OPT 1: primary_key

OPT 2: foreign_key

OPT 3: unique_key

OPT 4: check_constraint

OPT 5: property_list_anchor, property_list_element:
DB_PROPERTY_
DESCRIPTION
create_temporary_table pwszValue 1 1 REQ 1: coldef_list_anchor OPT 2: property_list_anchor,
property_list_element:
DB_PROPERTY_
DESCRIPTION
create_translation pwszValue 3 1 REQ 1: character_set_name

REQ 2: character_set_name

REQ 3: TBD

OPT 2: property_list_anchor,
property_list_element:
DB_PROPERTY_
DESCRIPTION
create_trigger pwszValue TBD TBD OPT 1: property_list_anchor,
property_list_element:
DB_PROPERTY_
DESCRIPTION
create_view pwszValue 1 1 REQ: T
OPT: property_list_anchor, property_list_element:
DB_PROPERTY_
CHECK_OPTION
drop_assertion pwszValue 0 1 OPT 1: property_list_anchor, property_list_element:
DB_PROPERTY_
DROP_CASCADE
drop_character_set pwszValue 0 1 OPT 1: property_list_anchor, property_list_element:
DB_PROPERTY_
DROP_CASCADE
drop_collation pwszValue 0 1 OPT 1: property_list_anchor, property_list_element:
DB_PROPERTY_
DROP_CASCADE
drop_domain pwszValue 0 1 OPT 1: property_list_anchor, property_list_element:
DB_PROPERTY_
DROP_CASCADE
drop_index pwszValue 0 0 OPT 1: property_list_anchor, property_list_element:
DB_PROPERTY_
DROP_CASCADE
drop_procedure pwszValue 0 1 OPT 1: property_list_anchor, property_list_element:
DB_PROPERTY_
DROP_CASCADE
drop_schema pwszValue 0 1 OPT 1: property_list_anchor, property_list_element:
DB_PROPERTY_
DROP_CASCADE
drop_synonym pwszValue
(local name for synonym)		 0 1 OPT 1: property_list_anchor property_list_element:
DB_PROPERTY_
DROP_CASCADE
drop_table pwszValue 0 1 OPT 1: property_list_anchor, property_list_element:
DB_PROPERTY_
DROP_CASCADE
drop_translation pwszValue 0 1 OPT 1: property_list_anchor, property_list_element:
DB_PROPERTY_
DROP_CASCADE
drop_trigger pwszValue 0 1 OPT 1: property_list_anchor, property_list_element:
DB_PROPERTY_
DROP_CASCADE
drop_view pwszValue 0 1 OPT 1: property_list_anchor, property_list_element:
DB_PROPERTY_DROP_CASCADE
foreign_key pwszValue2 2 1 REQ 1: column_list_anchor
REQ 2: referenced_table
OPT 1: column_list_anchor
grant_privileges 1 1 1st: TBD
2nd: TBD
index_list_anchor 0 1 OPT: index_list_element
index_list_element
primary_key pwszValue2 1 0 REQ 1: column_list_anchor
property_list_anchor DBVALUEKIND_
EMPTY		 0 1 OPT: property_list_element
property_list_element DBVALUEKIND_
EMPTY		 0 0
referenced_table pwszValue 0 0
rename_object pwszValue 0 0
revoke_privileges 1 1 1st: TBD
2nd: property_list_anchor, property_list_element:
DB_PROPERTY_
DROP_CASCADE
schema_authorization pwszValue 0 0
schema_name pwszValue 0 0
unique_key pwszValue 1 0 REQ 1: column_list_anchor
1    Only required if multiple property_list_element nodes are specified.

2    Optional.