Re: Moving a table to a different schema

On Thu, May 29, 2003 at 11:14:22AM -0500, Jim C. Nasby wrote:
> Is there a command to move an existing table to a different schema?

    CREATE TABLE targetschem.tablename AS
        SELECT * FROM sourceschem.tablename

would work.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110