Using an FdoFeatureSchema pSchema from the connection's schema collection, the following code should drop the feature class table (and the associated feature id sequence, if any):
// remove the class from the schema
FdoPtr<FdoClassCollection> pClassColl = pSchema->GetClasses();
FdoPtr<FdoClassDefinition> pClass =
pClassColl->FindItem(strFullClassName);
if ( pClass )
{
pClass->Delete();
// Create the ApplySchema command
FdoPtr<FdoIApplySchema> pApplySchemaCmd = dynamic_cast<FdoIApplySchema*>(
m_connection->CreateCommand(FdoCommandType_ApplySchema) );
// Set the schema and execute the apply schema command
pApplySchemaCmd->SetFeatureSchema(pSchema);
pApplySchemaCmd->Execute();
}
Whether the table needs to be empty seems to be under some debate currently. Regardless, the PostGIS provider does not possess this functionality at all.