Re: Student SQL question

From: Stanley Fung <sfung_at_mdsi.bc.ca>
Date: Wed, 20 May 1998 16:22:54 -0700
Message-ID: <356365CE.3CC2@mdsi.bc.ca>

Matt Brennan wrote:
>
> .....
> >the tablename cannot be changed (as far as I know)
>
> Haven't tried that myself, but I saw a post where someone else answered it.
>

Use RENAME command.

RENAME odlname to newname;

Stanley Fung                 | Software Analyst
Mobile Data Solutions Inc.   | Direct Line: (604)207-6290
Suite 135                    | Tel:         (604)270-9939
10551 Shellbridge Way,       | Fax:         (604)270-1310
Richmond, B.C.               | E-Mail:      sfung_at_mdsi.bc.ca
Canada V6X-2W9               | http://www.mdsi-advantex.com

------------------------------------------------------------

Received on Wed May 20 1998 - 18:22:54 CDT