ITableDefinitionWothConstraints Interface

IID_ITableDefinitionWithConstraints

{0C733AAB-2A1C-11CE-ADE5-00AA0044773D}

The ITableDefinitionWithConstraints interface exposes simple methods to create, drop, and alter tables on the data store. It also provides a mechanism to create and delete multitable and multicolumn constraints on tables.

Documentation: ITableDefinitionWithConstraints

Methods in VTable order

IUnknown Methods

Description

QueryInterface

Returns pointers to supported interfaces.

AddRef

Increments reference count.

Release

Decrements reference count.

ITableDefinition Methods

Description

CreateTable

Creates a new base table in the data store.

DropTable

Drops a base table in the data store.

AddColumn

Adds a new column to a base table.

DropColumn

Drops a column from a base table.

ITableCreation Methods

Description

GetTableDefinition

Adds a new column to a base table.

ITableDefinitionWithConstraints Methods

Description

AddConstraints

Adds a new constraint to a base table.

CreateTableWithConstraints

Creates a new base table in the data store, allowing constraints to be added atomically during table creation.

DropConstraint

Drops a constraint from a base table.

QueryInterface

FUNCTION ITableDefinitionWithConstraints_QueryInterface ( _

  BYVAL pthis AS DWORD PTR _

, BYREF riid AS GUID _

, BYREF ppvObj AS DWORD _

  ) AS LONG

  LOCAL HRESULT AS LONG
  CALL DWORD @@pthis[0] USING ITableDefinitionWithConstraints_QueryInterface (pthis, riid, ppvObj) TO HRESULT
  FUNCTION = HRESULT
 

END FUNCTION

AddRef

FUNCTION ITableDefinitionWithConstraints_AddRef ( _

  BYVAL pthis AS DWORD PTR _

  ) AS DWORD
 

  LOCAL DWRESULT AS LONG
  CALL DWORD @@pthis[1] USING ITableDefinitionWithConstraints_AddRef (pthis) TO DWRESULT
  FUNCTION = DWRESULT
 

END FUNCTION

Release

FUNCTION ITableDefinitionWithConstraints_Release ( _

  BYVAL pthis AS DWORD PTR _

  ) AS DWORD
 

  LOCAL DWRESULT AS DWORD
  CALL DWORD @@pthis[2] USING ITableDefinitionWithConstraints_Release (pthis) TO DWRESULT
  FUNCTION = DWRESULT
 

END FUNCTION

CreateTable

FUNCTION ITableDefinitionWithConstraints_CreateTable ( _
  BYVAL pthis AS DWORD PTR _

, BYVAL pUnkOuter AS DWORD _

, BYREF pTableID AS DBID _

, BYVAL cColumnDescs AS DWORD _

, BYVAL rgColumnDescs AS DWORD _

, BYREF riid AS GUID _

, BYVAL cPropertySets AS DWORD _

, BYREF rgPropertySets AS DWORD _

, BYREF ppTableID AS DBID _

, BYREF ppRowset AS DWORD _

  ) AS LONG

  LOCAL HRESULT AS LONG
  CALL DWORD @@pthis[3] USING ITableDefinitionWithConstraints_CreateTable (pthis, pUnkOuter, pTableID, cColumnDescs, rgColumnDescs, riid, cPropertySets, rgPropertySets, ppTableID, ppRowset) TO HRESULT
  FUNCTION = HRESULT

END FUNCTION

DropTable

FUNCTION ITableDefinitionWithConstraints_DropTable ( _
  BYVAL pthis AS DWORD PTR _

, BYREF pTableID AS DBID _

  ) AS LONG

  LOCAL HRESULT AS LONG
  CALL DWORD @@pthis[4] USING ITableDefinitionWithConstraints_DropTable (pthis, pTableID) TO HRESULT
  FUNCTION = HRESULT

END FUNCTION

AddColumn

FUNCTION ITableDefinitionWithConstraints_AddColumn ( _
  BYVAL pthis AS DWORD PTR _

, BYREF pTableID AS DBID _

, BYREF pColumnDesc AS DWORD _

, BYREF ppColumnID AS DBID _

  ) AS LONG

  LOCAL HRESULT AS LONG
  CALL DWORD @@pthis[5] USING ITableDefinitionWithConstraints_AddColumn (pthis, pTableID, pColumnDesc, ppColumnID) TO HRESULT
  FUNCTION = HRESULT

END FUNCTION

DropColumn

FUNCTION ITableDefinitionWithConstraints_DropColumn ( _
  BYVAL pthis AS DWORD PTR _

, BYREF pTableID AS DBID _

, BYREF pColumnID AS DBID _

  ) AS LONG

  LOCAL HRESULT AS LONG
  CALL DWORD @@pthis[6] USING ITableDefinitionWithConstraints_DropColumn (pthis, pTableID, pColumnID) TO HRESULT
  FUNCTION = HRESULT

END FUNCTION

GetTableDefinition

FUNCTION ITableDefinitionWithConstraints_GetTableDefinition ( _
  BYVAL pthis AS DWORD PTR _

, BYREF pTableID AS DBID _

, BYVAL pColumnDescs AS DWORD _

, BYREF prgColumnDescs AS DWORD _

, BYREF pcPropertySets AS DWORD _

, BYREF prgPropertySets AS DWORD _

, BYREF pcConstrainDescs AS DWORD _

, BYREF prgConstrainDescs AS DWORD _

, BYREF ppwszStringBuffer AS DWORD _

  ) AS LONG

  LOCAL HRESULT AS LONG
  CALL DWORD @@pthis[7] USING ITableDefinitionWithConstraints_GetTableDefinition (pthis, pTableID, pColumnDescs, prgColumnDescs, pcPropertySets, prgPropertySets, pcConstrainDescs, prgConstrainDescs, ppwszStringBuffer) TO HRESULT
  FUNCTION = HRESULT

END FUNCTION

AddConstraint

FUNCTION ITableDefinitionWithConstraints_AddConstraint ( _
  BYVAL pthis AS DWORD PTR _

, BYREF pTableID AS DBID _

, BYVAL pConstraintDesc AS DWORD _

  ) AS LONG

  LOCAL HRESULT AS LONG
  CALL DWORD @@pthis[8] USING ITableDefinitionWithConstraints_AddConstraint (pthis, pTableID, pConstraintDesc) TO HRESULT
  FUNCTION = HRESULT

END FUNCTION

CreateTableWithConstraints

FUNCTION ITableDefinitionWithConstraints_CreateTableWithConstraints ( _
  BYVAL pthis AS DWORD PTR _

, BYVAL pUnkOuter AS DWORD _

, BYREF pTableID AS DBID _

, BYVAL cColumnDescs AS DWORD _

, BYREF rgColumnDescs AS DWORD _

, BYVAL cConstraintDescs AS DWORD _

, BYVAL rgConstraintDescs AS DWORD _

, BYREF riid AS GUID _

, BYVAL cPropertySets AS DWORD _

, BYREF rgPropertySets AS DWORD _

, BYREF ppTableID AS DBID _

, BYREF ppRowset AS DWORD _

  ) AS LONG

  LOCAL HRESULT AS LONG
  CALL DWORD @@pthis[9] USING ITableDefinitionWithConstraints_CreateTableWithConstraints (pthis, pUnkOuter, pTableID, cColumnDescs, rgColumnDescs, cConstraintDescs, rgConstraintDescs, riid, cPropertySets, rgPropertySets, ppTableID, ppRowset) TO HRESULT
  FUNCTION = HRESULT

END FUNCTION

DropConstraint

FUNCTION ITableDefinitionWithConstraints_DropConstraint ( _
  BYVAL pthis AS DWORD PTR _

, BYREF pTableID AS DBID _

, BYREF pConstraintID AS DBID _

  ) AS LONG

  LOCAL HRESULT AS LONG
  CALL DWORD @@pthis[10] USING ITableDefinitionWithConstraints_DropConstraint (pthis, pTableID, pConstraintID) TO HRESULT
  FUNCTION = HRESULT

END FUNCTION