Re: How to rename tables and fields using SQL?

From: Laser Lu (lu_yanfeng_at_hotmail.com)
Date: 02/02/04 

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?
Right?

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" <lu_yanfeng@hotmail.com> wrote in message
news:#OV2crL6DHA.2480@TK2MSFTNGP12.phx.gbl...
> > help!
> >
> > --
> > Best regards,
> > Laser Lu
> > "Laser Lu" <lu_yanfeng@hotmail.com> wrote in message
> > news:ejBp6uJ6DHA.3304@tk2msftngp13.phx.gbl...
> > > Can tables and fiels be renamed in SQL? How to rename those schema
objects
> > > by using DDL?
> > >
> > > --
> > > Best regards,
> > > Laser Lu
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Change File name case
    ... Thanks for the response Randy, That is what I ended up doing. ... > existing filename when not changing the filename itself you had to name ... > to append an x to the name, change the case, and rename back. ... >: Thanks You, Dan... ...
    (comp.lang.basic.visual.misc)
  • Re: - How do I rename print-to-file filename at runtime?
    ... Can't you just rename the file after creating it? ... Dan wrote: ... > I am trying to convert a bunch of different format files ...
    (microsoft.public.fox.programmer.exchange)
  • Re: - How do I rename print-to-file filename at runtime?
    ... The process is run on the network - renaming afterwards is unrealizable. ... actually renames the port file name (without manually changing it in the ... > Can't you just rename the file after creating it? ... > Dan wrote: ...
    (microsoft.public.fox.programmer.exchange)
  • Re: How to rename tables and fields using SQL?
    ... To rename a field, you have to first create a new field with the name you want, ... How to rename those schema objects ... >> Best regards, ... >> Laser Lu ...
    (microsoft.public.access.queries)
  • Re: filenames and cases
    ... Are you using SP1 of VFP 8.0? ... > Hi Dan ... > RENAME doesn't respect my case. ...
    (microsoft.public.fox.programmer.exchange)