Data Definition Operators

[This is preliminary documentation and subject to change.]

All scalar-, row-, table-, and Boolean-valued expressions required by DDL operators are represented in the same way as in DML expressions.

DBOP_alter_character_set

Node used to alter the definition of an existing character set. The name of the character set to be altered is specified directly by this node.

DBOP_alter_collation

Node used to alter the definition of an existing collation. The name of the collation to be altered is specified directly by this node.

DBOP_alter_domain

Node used to alter the definition of an existing domain. The name of the domain to be altered is specified directly by this node.

DBOP_alter_index

Node used to alter the definition of an existing index. The name of the index to be altered is specified directly by this node.

DBOP_alter_procedure

Node used to alter the definition of an existing procedure. The name of the procedure to be altered is specified directly by this node.

DBOP_alter_schema

Node used to alter the definition of an existing schema. The name of the schema to be altered is specified directly by this node.

DBOP_alter_table

Node used to alter the definition of an existing table. The name of the table to be altered is specified directly by this node.

DBOP_alter_trigger

Node used to alter the definition of an existing trigger. The name of the trigger to be altered is specified directly by this node.

DBOP_alter_view

Node used to alter the definition of an existing view. The name of the view to be altered is specified directly by this node.

DBOP_coldef_list_anchor

Node identifying the start of a list of coldef_list_element nodes.

DBOP_coldef_list_element

Node used to specify the definition of a column (typically in conjunction with a create_table node). Note that this node does not attempt to describe all of the properties that may be associated with a column, but just the basic, immutable properties. More elaborate properties can be added to the column definition by adding a property_list_anchor and subsequent property_list_element nodes.

DBOP_create_assertion

Node used to specify creation of an assertion. An assertion is a standalone constraint in a schema and is typically used to specify a constraint that affects more than one table. The name of the assertion to be created is specified directly by this node.

DBOP_create_character_set

Node used to specify creation of a character set. A character set is a collection of characters used to create character strings. is The name of the character set to be created is specified directly by this node.

DBOP_create_collation

Node used to specify creation of a collation. A collation is a set of rules that control how strings in a character set are compared. The name of the collation to be created is specified directly by this node.

DBOP_create_domain

Node used to specify creation of a domain. A domain is a named meta data type which can be used to specify a data type length as well as a default value, constraints, and collations. The name of the domain to be created is specified directly by this node.

DBOP_create_index

Node used to specify creation of an index. The name of the index to be created is specified directly by this node.

DBOP_create_procedure

Node used to specify creation of a procedure. The name of the procedure to be created is specified directly by this node.

DBOP_create_schema

Node used to specify creation of a schema.

DBOP_create_synonym

Defines a synonym (attached table) in the local schema for a table in an outside data source. The node takes one required and one optional input. The required input is a DBOP_table_name operator denoting the synonym name. The local synonym name is represented in the pwszValue field of the DBOP_create_synonym node. The first required input is a DBOP_table_name defining the name of the table in the external data source. The naming follows the scheme used by table names. The second optional input is a DBOP_property_list_anchor which contains a list of DBOP_property_list_elements defining the external data source. If there is no second child, the synonym is assumed to be local.

DBOP_create_table

Node used to specify creation of a table. The name of the table to be created is specified directly by this node.

DBOP_create_temporary_table

Node used to specify creation of a temporary table. The name of the table to be created is specified directly by this node.

DBOP_create_translation

Node used to specify creation of a translation. A translation specifies how to translate from one character set to another. The name of the translation to be created is specified directly by this node.

DBOP_create_trigger

Node used to specify creation of a trigger. A trigger specifies what actions to perform after certain actions have occurred in the DBMS. The name of the trigger to be created is specified directly by this node.

DBOP_create_view

Node used to specify creation of a view. The name of the view to be created is specified directly by this node. The node takes two inputs. The first required input is a table-valued expression defining the contents of the view. The columns resulting from this expression are exactly the columns of the view. The second optional input is a DBOP_property_list_anchor node with one DBOP_property_list_element node to specify the DB_PROPERTY_CHECK_OPTION property. If the value of this property is TRUE, this is equivalent to the WITH LOCAL CHECK OPTION clause; if the value of this property is FALSE, this is equivalent to the WITH CASCADED CHECK OPTION clause (which is the default).

DBOP_drop_assertion

Node used to specify deletion of a assertion. The name of the assertion to be deleted is specified directly by this node.

DBOP_drop_character_set

Node used to specify deletion of a character set. The name of the character set to be deleted is specified directly by this node.

DBOP_drop_collation

Node used to specify deletion of a collation. The name of the collation to be deleted is specified directly by this node.

DBOP_drop_domain

Node used to specify deletion of a domain. The name of the domain to be deleted is specified directly by this node.

DBOP_drop_index

Node used to specify deletion of a index. The name of the index to be deleted is specified directly by this node.

DBOP_drop_procedure

Node used to specify deletion of a procedure. The name of the procedure to be deleted is specified directly by this node.

DBOP_drop_schema

Node used to specify deletion of a schema. The name of the schema to be deleted is specified directly by this node.

DBOP_drop_synonym

Removes a synonym from the local schema; the name of the synonym is included in the node in the pwszValue field.

DBOP_drop_table

Node used to specify deletion of a table. The name of the table to be deleted is specified directly by this node.

DBOP_drop_translation

Node used to specify deletion of a translation. The name of the translation to be deleted is specified directly by this node.

DBOP_drop_trigger

Node used to specify deletion of a trigger. The name of the trigger to be deleted is specified directly by this node.

DBOP_drop_view

Node used to specify deletion of a view. The name of the view to be deleted is specified directly by this node.

DBOP_foreign_key

Node used to define a Foreign Key.

DBOP_grant_privileges

Node used to grant privileges on an object.

DBOP_index_list_anchor

Node identifying the start of a list of DBOP_index_list_element nodes.

DBOP_index_list_element

Each index list element contains the name of an index and an optional table name.

DBOP_primary_key

Node used to define a Primary Key.

DBOP_property_list_anchor

Node identifying the start of a list of DBOP_property_list_element nodes.

DBOP_property_list_element

Node used to specify a property for an object. This is a generic node consisting of a GUID and a VARIANT. The GUID represents the property to set and the VARIANT the value to set the property to. OLE DB specifies a set of "well-known" properties (see below) that can be used to define properties for an object. Individual providers may also define GUIDs representing "extended properties" that the provider supports that can also be set using this node.

DBOP_referenced_table

Node used to specify the referenced table in a Primary Key-Foreign Key relationship.

DBOP_rename_object

Node used to specify the new name of an object being renamed via a DBOP_alter_objecttype node.

DBOP_revoke_privileges

Node used to revoke privileges from an object.

DBOP_schema_authorization

Node used to specify the authorization name for schema creation.

DBOP_schema_name

Node used to specify the user name associated with a schema for schema creation.

DBOP_unique_key

Node used to define a Unique Key.

Connecting DML and DDL Command Nodes