doctrine / dbal

     *

     * @link http://msdn.microsoft.com/en-us/library/ms180047%28v=sql.90%29.aspx

     */

    public function getAddExtendedPropertySQL(

        $name,

        $value = null,

        $level0Type = null,

        $level0Name = null,

        $level1Type = null,

        $level1Name = null,

        $level2Type = null,

        $level2Name = null

    ) {

        return "EXEC sp_addextendedproperty " .

            "N" . $this->quoteStringLiteral($name) . ", N" . $this->quoteStringLiteral($value) . ", " .

            "N" . $this->quoteStringLiteral($level0Type) . ", " . $level0Name . ', ' .

            "N" . $this->quoteStringLiteral($level1Type) . ", " . $level1Name . ', ' .

            "N" . $this->quoteStringLiteral($level2Type) . ", " . $level2Name;

    }

    /**

     * Returns the SQL statement for dropping an extended property from a database object.

     *

     * @link http://msdn.microsoft.com/en-us/library/ms186885%28v=sql.90%29.aspx

     */

    public function getUpdateExtendedPropertySQL(

        $name,

        $value = null,

        $level0Type = null,

        $level0Name = null,

        $level1Type = null,

        $level1Name = null,

        $level2Type = null,

        $level2Name = null

    ) {

        return "EXEC sp_updateextendedproperty " .

        "N" . $this->quoteStringLiteral($name) . ", N" . $this->quoteStringLiteral($value) . ", " .

        "N" . $this->quoteStringLiteral($level0Type) . ", " . $level0Name . ', ' .

        "N" . $this->quoteStringLiteral($level1Type) . ", " . $level1Name . ', ' .

        "N" . $this->quoteStringLiteral($level2Type) . ", " . $level2Name;

    }

    /**

     * {@inheritDoc}