PHP dropDefaultValueMSSQL示例

示例#1

文件： updatedb_helper.php 项目： CSCI-462-01-2016/LimeSurvey

/**
 * @param string $sTableName
 * @param string $sColumnName
 */
function dropColumn($sTableName, $sColumnName)
{
    if (Yii::app()->db->getDriverName() == 'mssql' || Yii::app()->db->getDriverName() == 'sqlsrv' || Yii::app()->db->getDriverName() == 'dblib') {
        dropDefaultValueMSSQL($sColumnName, $sTableName);
    }
    Yii::app()->db->createCommand()->dropColumn($sTableName, $sColumnName);
}

示例#2

文件： updatedb_helper.php 项目： jdbaltazar/survey-office

function dropColumn($sTableName, $sColumnName)
{
    $sDBDriverName = Yii::app()->db->getDriverName();
    if ($sDBDriverName == 'mysqli') {
        $sDBDriverName = 'mysql';
    }
    if ($sDBDriverName == 'sqlsrv' || $sDBDriverName == 'dblib') {
        $sDBDriverName = 'mssql';
    }
    if ($sDBDriverName == 'mssql') {
        dropDefaultValueMSSQL($sColumnName, $sTableName);
    }
    Yii::app()->db->createCommand()->dropColumn($sTableName, $sColumnName);
}