/**
* @inheritdoc
*/
public function dropTable($table)
{
$sql = parent::dropTable($table);
$tableSchema = $this->db->getTableSchema($table);
if ($tableSchema === null || $tableSchema->sequenceName === null) {
return $sql;
}
$sqlBlock = <<<SQL
EXECUTE block AS
BEGIN
EXECUTE STATEMENT {$this->db->quoteValue($sql)};
EXECUTE STATEMENT {$this->db->quoteValue("DROP SEQUENCE {$tableSchema->sequenceName}")};
END;
SQL;
return $sqlBlock;
}