mySQL has a statement to do this is one hit
http://dev.mysql.com/doc/refman/5.0/en/rename-table.html
I would expect other engines do as well?
On 28 September 2010 12:23, Blair McKenzie <[email protected]> wrote:
> I would have to drop the table then recreate it, presumably querying first
> then re-inserting every record afterwards. Not sure how practical that is.
>
>
> On Tue, Sep 28, 2010 at 1:46 PM, AJ Mercer <[email protected]> wrote:
>
>> Blair,
>>
>> can you add a alterTable to change table name to match the casing of the
>> filename?
>>
>> On 28 September 2010 11:35, Blair McKenzie <[email protected]> wrote:
>>
>>> I did the refactoring on a Linux desktop. Of course I may have turned of
>>> case sensitivity sometime in the distant past, so I can't be certain it
>>> won't be a problem. If it turns out case is still an issue I would
>>> personally prefer that the case of the table match the case of the
>>> component.
>>>
>>> Blair
>>>
>>>
>>>
>>> On Tue, Sep 28, 2010 at 1:12 PM, Michael Sharman <[email protected]>wrote:
>>>
>>>> I have a farcry 5.2.7 project which I've upgraded to 6.1 but have
>>>> noticed that a lot of the table names have changed case from what they
>>>> were previously (after updating the coapi).
>>>>
>>>> Tables like:
>>>> dmarchive (was dmArchive)
>>>> dmevent (was dmEvent)
>>>> etc
>>>>
>>>> We've previously had a few issues with database table names as we run
>>>> on Linux, I'm on a mac at the moment so I can't do a test yet. My
>>>> question...is this correct? Is there a naming "convention" for
>>>> database tables, at least the core ones? I have a funny feeling if I
>>>> ran this on linux it would fail.
>>>>
>>>> Should the naming convention be headless camel case; so dmImage
>>>> instead of dmimage etc? Same for any far** prefixed tables.
>>>>
>>>> Thanks.
>>>>
>>>> --
>>>> You received this message cos you are subscribed to "farcry-dev" Google
>>>> group.
>>>> To post, email: [email protected]
>>>> To unsubscribe, email:
>>>> [email protected]<farcry-dev%[email protected]>
>>>> For more options: http://groups.google.com/group/farcry-dev
>>>> --------------------------------
>>>> Follow us on Twitter: http://twitter.com/farcry
>>>
>>>
>>> --
>>> You received this message cos you are subscribed to "farcry-dev" Google
>>> group.
>>> To post, email: [email protected]
>>> To unsubscribe, email:
>>> [email protected]<farcry-dev%[email protected]>
>>> For more options: http://groups.google.com/group/farcry-dev
>>> --------------------------------
>>> Follow us on Twitter: http://twitter.com/farcry
>>>
>>
>>
>>
>> --
>>
>> *AJ Mercer*
>> <webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org
>> community="Open" /> <http://webonix.org>
>> http://twitter.com/webonix
>>
>> --
>> You received this message cos you are subscribed to "farcry-dev" Google
>> group.
>> To post, email: [email protected]
>> To unsubscribe, email:
>> [email protected]<farcry-dev%[email protected]>
>> For more options: http://groups.google.com/group/farcry-dev
>> --------------------------------
>> Follow us on Twitter: http://twitter.com/farcry
>>
>
> --
> You received this message cos you are subscribed to "farcry-dev" Google
> group.
> To post, email: [email protected]
> To unsubscribe, email:
> [email protected]<farcry-dev%[email protected]>
> For more options: http://groups.google.com/group/farcry-dev
> --------------------------------
> Follow us on Twitter: http://twitter.com/farcry
>
--
*AJ Mercer*
<webonix:net strength="Industrial" /> <http://webonix.net> | <webonix:org
community="Open" /> <http://webonix.org>
http://twitter.com/webonix
--
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: [email protected]
To unsubscribe, email: [email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
