Re: Help Please...

From: Mike Jay <mikejay_at_mitre.org>
Date: Tue, 02 Oct 2001 11:18:44 -0400
Message-ID: <3BB9DAD4.CD51B19A@mitre.org>

ALTER TABLE schema.table RENAME TO new_table_name ;

Check any dependent views.

Rob Panosh wrote:
>
> Hi,
>
> In Microsoft SQL server to rename an existing table I would call a system
> stored proc sp_rename <table name>, <new tabe name>. Can I rename a table
> in Oracle? If so could somebody please provide an example.
>
> Thanks,
> --
> Rob Panosh
> Advanced Software Designs
Received on Tue Oct 02 2001 - 10:18:44 CDT