OracleConnection::dropTable

public function dropTable($tableName)
{
	$this->query('DROP TABLE '.$this->getSqlHelper()->quote($tableName).' CASCADE CONSTRAINTS');

	// handle auto increment: delete primary sequence for ID
	// properly we should check PRIMARY fields instead of ID: $aiName = $currentName.'_'.$fieldName, see createTable
	$aiName = $tableName;

	if ($this->queryScalar("SELECT 1 FROM user_sequences WHERE sequence_name=upper('".$this->getSqlHelper()->forSql('sq_'.$aiName)."')"))
	{
		$this->query('DROP SEQUENCE '.$this->getSqlHelper()->quote('sq_'.$aiName));
	}
}