Re: How to rename tables and fields using SQL?
From: Laser Lu (lu_yanfeng_at_hotmail.com)
Date: Mon, 2 Feb 2004 11:02:50 +0800
Tank you, Dan!
Then how about rename a table? Create a new table and then copy the data
from the original table into the new table using the SELECT statement?
And since there is no good solution on SQL, is there any other programable
interfaces for renaming tables and fields?
-- Best regards, Laser Lu "Dan Artuso" <dartuso@NSpagepearls.com> wrote in message news:ehAVaKO6DHA.1592@TK2MSFTNGP10.phx.gbl... > Hi, > To rename a field, you have to first create a new field with the name you want, > copy all the data from the old field to the new, then drop the old field. > > For exact syntax, look up Alter Table in Help. You can use an Update statement to > copy the data. > > -- > HTH > Dan Artuso, Access MVP > > > "Laser Lu" <email@example.com> wrote in message news:#OV2crL6DHA.2480@TK2MSFTNGP12.phx.gbl... > > help! > > > > -- > > Best regards, > > Laser Lu > > "Laser Lu" <firstname.lastname@example.org> wrote in message > > news:ejBp6uJ6DHA.email@example.com... > > > Can tables and fiels be renamed in SQL? How to rename those schema objects > > > by using DDL? > > > > > > -- > > > Best regards, > > > Laser Lu > > > > > > > > > > > >