dropTable() public méthode

Builds a SQL statement for dropping a DB table.
public dropTable ( string $table ) : string
$table string the table to be dropped. The name will be properly quoted by the method.
Résultat string the SQL statement for dropping a DB table.
QueryBuilder Class Documentation
Exemple #1
0
    /**
     * @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;
    }