Final Class Yiisoft\Db\Mssql\DDLQueryBuilder

                public function addCommentOnColumn(string $table, string $column, string $comment): string
{
    return $this->buildAddCommentSql($comment, $table, $column);
}

            

                public function addCommentOnTable(string $table, string $comment): string
{
    return $this->buildAddCommentSql($comment, $table);
}

            

                public function addDefaultValue(string $table, string $name, string $column, mixed $value): string
{
    return 'ALTER TABLE '
        . $this->quoter->quoteTableName($table)
        . ' ADD CONSTRAINT '
        . $this->quoter->quoteColumnName($name)
        . ' DEFAULT ' . $this->queryBuilder->prepareValue($value)
        . ' FOR ' . $this->quoter->quoteColumnName($column);
}

            

                public function alterColumn(string $table, string $column, ColumnInterface|string $type): string
{
    $columnName = $this->quoter->quoteColumnName($column);
    $tableName = $this->quoter->quoteTableName($table);
    $constraintBase = preg_replace('/\W/', '', $table . '_' . $column);
    if (is_string($type)) {
        $type = $this->queryBuilder->getColumnFactory()->fromDefinition($type);
    }
    $columnDefinitionBuilder = $this->queryBuilder->getColumnDefinitionBuilder();
    $statements = [
        $this->dropConstraintsForColumn($table, $column, 'D'),
        "ALTER TABLE $tableName ALTER COLUMN $columnName " . $columnDefinitionBuilder->buildAlter($type),
    ];
    if ($type->hasDefaultValue()) {
        $defaultValue = $type->dbTypecast($type->getDefaultValue());
        $statements[] = $this->addDefaultValue($table, "DF_$constraintBase", $column, $defaultValue);
    }
    $checkValue = $type->getCheck();
    if (!empty($checkValue)) {
        $statements[] = "ALTER TABLE $tableName ADD CONSTRAINT "
            . $this->quoter->quoteColumnName("CK_$constraintBase")
            . " CHECK ($checkValue)";
    }
    if ($type->isUnique()) {
        $statements[] = "ALTER TABLE $tableName ADD CONSTRAINT "
            . $this->quoter->quoteColumnName("UQ_$constraintBase")
            . " UNIQUE ($columnName)";
    }
    return implode("\n", $statements);
}

            

                public function checkIntegrity(string $schema = '', string $table = '', bool $check = true): string
{
    $enable = $check ? 'CHECK' : 'NOCHECK';
    /** @psalm-var Schema $schemaInstance */
    $schemaInstance = $this->schema;
    $defaultSchema = $schema ?: $schemaInstance->getDefaultSchema();
    /** @psalm-var string[] $tableNames */
    $tableNames = $schemaInstance->getTableSchema($table)
         ? [$table] : $schemaInstance->getTableNames($defaultSchema);
    $viewNames = $schemaInstance->getViewNames($defaultSchema);
    $tableNames = array_diff($tableNames, $viewNames);
    $command = '';
    foreach ($tableNames as $tableName) {
        $tableName = $this->quoter->quoteTableName("$defaultSchema.$tableName");
        $command .= "ALTER TABLE $tableName $enable CONSTRAINT ALL; ";
    }
    return $command;
}

            

                public function createIndex(
    string $table,
    string $name,
    array|string $columns,
    ?string $indexType = null,
    ?string $indexMethod = null,
): string {
    return 'CREATE ' . (!empty($indexType) ? $indexType . ' ' : '') . 'INDEX '
        . $this->quoter->quoteTableName($name) . ' ON '
        . $this->quoter->quoteTableName($table)
        . (!empty($columns) ? ' (' . $this->queryBuilder->buildColumns($columns) . ')' : '')
        . (!empty($indexMethod) ? " USING $indexMethod" : '');
}

            

                public function dropColumn(string $table, string $column): string
{
    return $this->dropConstraintsForColumn($table, $column)
        . "\nALTER TABLE "
        . $this->quoter->quoteTableName($table)
        . ' DROP COLUMN '
        . $this->quoter->quoteColumnName($column);
}

            

                public function dropCommentFromColumn(string $table, string $column): string
{
    return $this->buildRemoveCommentSql($table, $column);
}

            

                public function dropCommentFromTable(string $table): string
{
    return $this->buildRemoveCommentSql($table);
}

            

                public function dropDefaultValue(string $table, string $name): string
{
    return 'ALTER TABLE '
        . $this->quoter->quoteTableName($table)
        . ' DROP CONSTRAINT '
        . $this->quoter->quoteColumnName($name);
}

            

                public function dropTable(string $table, bool $ifExists = false, bool $cascade = false): string
{
    if ($cascade) {
        throw new NotSupportedException('MSSQL doesn\'t support cascade drop table.');
    }
    return parent::dropTable($table, $ifExists, false);
}

            

                public function renameColumn(string $table, string $oldName, string $newName): string
{
    return 'sp_rename '
        . "'" . $this->quoter->quoteTableName($table) . '.' . $this->quoter->quoteColumnName($oldName) . "'" . ', '
        . $this->quoter->quoteColumnName($newName) . ', '
        . "'COLUMN'";
}

            

                public function renameTable(string $oldName, string $newName): string
{
    return 'sp_rename '
        . $this->quoter->quoteTableName($oldName) . ', '
        . $this->quoter->quoteTableName($newName);
}