Yup. Actually, many flavours of SQL support table renaming or table duplication with additional keywords on ALTER TABLE since, at least in SQL92 AFAIK it wasn't supported as part of the DDL.
For example, the last time I used MySQL with the Sequel Pro GUI tool, It has a table duplication menu option which gives you the option to rename a table and also copies the data for you. This menu option is possible is because in MySQL the ALTER TABLE command supports the LIKE keyword, thus allowing you to do something like: CREATE TABLE newTable LIKE oldTable; INSERT newTable SELECT * FROM oldTable; Regards, Narinder Chandi, ToolBox Systems Ltd. -- -----Original Message----- From: 4D_Tech <[email protected]> on behalf of 4D Tech Mailing List <[email protected]> Organization: The Aquila Group, Inc. Reply-To: <[email protected]>, 4D Tech Mailing List <[email protected]> Date: Friday, 26 July 2019 at 19:56 To: 4D Tech Mailing List <[email protected]>, 'Tom Benedict' <[email protected]> Cc: "Stephen J. Orth" <[email protected]> Subject: RE: SQL - renaming a field Chip, That kind of sucks because doesn't a "drop" destroy data? Steve -----Original Message----- From: 4D_Tech <[email protected]> On Behalf Of Chip Scheide via 4D_Tech Sent: Friday, July 26, 2019 1:46 PM To: Tom Benedict <[email protected]> Cc: Chip Scheide <[email protected]>; 4D iNug Technical <[email protected]> Subject: Re: SQL - renaming a field OK Thanks both I guess rename is only possible as Drop + Add 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] ********************************************************************** ********************************************************************** 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] **********************************************************************
