OK Thanks both
I guess rename is only possible as Drop + Add Chip On Fri, 26 Jul 2019 11:42:49 -0700, Tom Benedict wrote: > 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 --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 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] **********************************************************************
