[DBAL-199] MSSQL change column name Created: 15/Nov/11  Updated: 14/Nov/12  Resolved: 09/Jan/12

Status: Resolved
Project: Doctrine DBAL
Component/s: Platforms
Affects Version/s: 2.1.2, 2.1.7
Fix Version/s: None
Security Level: All

Type: Bug Priority: Major
Reporter: Diego Vidal Assignee: Benjamin Eberlei
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Symfony console, MSSQL Server 2008 r2



 Description   

Hello,

to create a schema for mssql works ok, but to alter the name of a column, use the SQL command "CHANGE" and Mssql not recognize this command.
to alter the name of a column in MSSQL you should use the store procedure "sp_rename"

http://msdn.microsoft.com/en-us/library/ms188351.aspx

Do not know if I'm doing something the wrong way, but the command "php app \ console doctrine: schema: update" does not work by altering the name of the column

sorry my english it's very poor



 Comments   
Comment by Fred Jiles [ 30/Nov/11 ]

I get this error as well. Just trying to change a field from nvarchar(40) to nvarchar(60) outputs this sql
ALTER TABLE offense_extension CHANGE disposition disposition NVARCHAR(60) DEFAULT NULL

It should be ALTER TABLE offense_extension ALTER COLUMN disposition NVARCHAR(60) NULL

Comment by Benjamin Eberlei [ 09/Jan/12 ]

This is fixed in another ticket i just realized and is included in the latest 2.1 DBAL release.

Comment by PandD [ 14/Nov/12 ]

This problem still exists.

Here are some of the sql lines generated with :

ALTER TABLE msrs CHANGE Temp27 Temp27 SMALLINT NOT NULL;
ALTER TABLE batches CHANGE status status BIT DEFAULT NULL;

Doctrine DBAL Version: 2.1.7
MSSQL 2008 R2

Generated at Mon Sep 22 16:26:17 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.