SQLAnywhere supports! ALTER TABLE "tablename" RENAME "oldcolumnname" TO "bewcolumnname";
-- José Henrique (Zote) Analista de TI Bludata Software On Fri, Nov 14, 2014 at 5:48 AM, Jan Schubert <[email protected]> wrote: > Fantastic! I will try it today. > > Thank you for your great support! > > > Am Donnerstag, 13. November 2014 22:58:10 UTC+1 schrieb Jeffrey Becker: > >> All updated, have-at. >> >> On Thursday, November 13, 2014 3:44:12 PM UTC-5, Alexander Zaytsev wrote: >>> >>> I've implemented rename for MySQL in FluentMigrator >>> https://github.com/schambers/fluentmigrator/pull/166/ >>> >>> Best Regards, >>> Alexander >>> >>> On Fri, Nov 14, 2014 at 8:44 AM, Jan Schubert <[email protected]> >>> wrote: >>> >>>> 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 [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
