Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Rename Table
Fri, Mar 28 2008 1:28 PMPermanent Link

QuickAndDirty
Hello,
I really  tried hard but didn't  get it.
Is there a replacemant in SQL for the RenameTable Method?
One that doesn't require to copy all data to a new table and drop the old one?

I tried to change the Information.Tables and so on...
ALTER TABLE seems to give nothing in this direction....

Is there a way with the new ElevateDB Version to rename your table ?
Fri, Mar 28 2008 3:09 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< Is there a replacemant in SQL for the RenameTable Method?
One that doesn't require to copy all data to a new table and drop the old
one? >>

The ability to rename database objects will be in ElevateDB 2.0.

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Mar 28 2008 7:34 PMPermanent Link

Rony Gellaerts
Tim Young [Elevate Software] wrote:
> << Is there a replacemant in SQL for the RenameTable Method?
>  One that doesn't require to copy all data to a new table and drop the old
> one? >>
>
> The ability to rename database objects will be in ElevateDB 2.0.
>

Tim,

Also for existing fields in a table ? Because now you cannot alter
fieldnames (existing columns) to rename to another name.

Rony Gellaerts
Mon, Mar 31 2008 3:12 AMPermanent Link

QuickAndDirty
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
The ability to rename database objects will be in ElevateDB 2.0.

OK Tim,
I'am hot for the new Version. Smile
Mon, Mar 31 2008 4:37 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Rony,

<< Also for existing fields in a table ? Because now you cannot alter
fieldnames (existing columns) to rename to another name. >>

Yes.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image