[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 Fri May 24 04:05:48 UTC 2013 using JIRA 5.2.7#850-sha1:b2af0c8dc8537b36121c6a579fabbdf79fc919e5.