Re: RealSQL questions

[Tehenne <tehenne at wanadoo dot fr>]

Le 31 oct. 05 à 20:52, Norman Palardy a écrit :

> On Oct 31, 2005, at 5:31 AM, Tehenne wrote:
>
>
> > Hello
> >
> > First question  :
> > Is it possible to rename a column in a table ?
> > If yes, how?
>  A long an involved process (and only some of it possible in the IDE)
>
>     Make a new table that has the same columns as the existing one  
> with the column you want renamed omitted and replaced by the new name
>     Insert all the data to it by
>         insert into newTable (columns list ) values ( select ....  
> from oldTable )
>         where the select lists the old columns in the order they  
> are in the new table list
>     Drop the original (old) table
>
>     rename the new table
>
>             alter table newTableName Rename To OldTableName
>
>     vacuum
Thanks for your answers which completely satisfy me

--
Tehenne        Saint-Denis de la Réunion


_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>