recreate it from your DDL, insert the data accross, then remove the old
table.

:)

or write the equivilent of sp_rename and messes with the RDB$ tables. Not
recommended tho

N

--
Nic Wise - [EMAIL PROTECTED] / Inprise/Borland New Zealand
main line: 09.360.0231 / ddi: 09.360.6713 / cell: 021.676.418



> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Matthew Comb
> Sent: Wednesday, 13 September 2000 11:56
> To: Multiple recipients of list delphi
> Subject: [DUG]: Interbase rename.
>
>
> I notice that interbase doesn't recognise the rename call. How do
> you rename
> a table?
>
> Matt.
>
> ------------------------------------------------------------------
> ---------
>     New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
>                   Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>

---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED] 
with body of "unsubscribe delphi"

Reply via email to