Dropping a SQL Server Table
The SQL Server Native Client OLE DB provider exposes the ITableDefinition::DropTable function. This allows consumers to remove a Microsoft SQL Server table from a database.
Consumers specify the table name as a Unicode character string in the pwszName member of the uName union in the pTableID parameter. The eKind member of pTableID must be DBKIND_NAME.