Not all dialects support rename columns.
No support found for Firebird and SQLite.
MySQL needs the data type to change the column name:
ALTER TABLE "tablename" Change "oldcolumnname" "newcolumnname" ["Data Type"]
Other dialects:
Oracle = alter table tablename rename column oldcolumnname to newcolumnname
DB2 = ALTER TABLE tablename RENAME COLUMN oldcolumnname TO newcolumnname
Ingres = ALTER TABLE tablename RENAME COLUMN oldcolumnname TO newcolumnname
PostgreSQL = ALTER TABLE tablename RENAME COLUMN oldcolumnname TO
newcolumnname
Sybase = sp_rename 'tablename.oldcolumnname', 'newcolumnname'
Am Donnerstag, 13. November 2014 19:56:11 UTC+1 schrieb Jeffrey Becker:
>
> I'm going to build in support in my repo shortly. If you could check the
> other dialects for column renaming support and let me know, that'd be
> awesome.
>
> In the mean-time you can always:
>
> Run(new SqlDdlOperation("EXEC sp_rename 'Test.Example',
> 'BetterExample', 'COLUMN';"));
>
> or implement a RenameColumnOperation and Run that.
>
> On Thursday, November 13, 2014 1:41:21 PM UTC-5, Jan Schubert wrote:
>>
>> Yes, that I mean. It is possible to rename a column with sp_rename on
>> mssql.
>>
>> EXEC sp_rename 'Test.Example', 'BetterExample', 'COLUMN';
>>
>>
>> Am Donnerstag, 13. November 2014 15:26:45 UTC+1 schrieb Jeffrey Becker:
>>>
>>> er. Do you mean having a method off the fluent builder something like:
>>>
>>> surface.Alter.Table("Test").RenameColumn("Example", "BetterExample");
>>>
>>>
>>>
>>> On Thursday, November 13, 2014 7:37:51 AM UTC-5, Jeffrey Becker wrote:
>>>>
>>>> I doubt it. Afaik, sql (or at least the mssqlserver dialect) doesn't
>>>> support renaming columns in the alter syntax. That an IDdlOperation which
>>>> generates the correct ddl shouldn't be hard to whip up.
>>>> On Nov 13, 2014 7:03 AM, "Jan Schubert" wrote:
>>>>
>>>>> You add support for altering columns, but it is possible to rename a
>>>>> column with ALTER? I saw your migration framework (Alpha) cannot rename a
>>>>> column.
>>>>>
>>>>> --
>>>>>
>>>>>
>>>>>
--
---
You received this message because you are subscribed to the Google Groups
"nhibernate-development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to nhibernate-development+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
