Maybe 4D’s SQL implementation doesn’t support the RENAME keyword? I don’t see it in the docs.. https://doc.4d.com/4Dv16/4D/16/ALTER-TABLE.300-3201314.en.html <https://doc.4d.com/4Dv16/4D/16/ALTER-TABLE.300-3201314.en.html>
Tom Benedict > On Jul 26, 2019, at 11:30, Chip Scheide via 4D_Tech <[email protected]> > wrote: > > I'm trying to use SQL to rename an existing field > $Sql:="Alter table ["+$Table_Name+"] Rename "+"Unused"+" to > "+$Field_Name+";" > > When executed I get a parsing error at 'Rename'. > > can someone better versed either correct my above syntax, or point out > a way to rename an existing field using SQL, -- preferably without > dropping and then adding. > > Thanks > Chip ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
