SQL server does. Then the trick is going to be knowing when it is warranted. Is it only for fixing table case?
On Tue, Sep 28, 2010 at 2:55 PM, AJ Mercer <[email protected]> wrote: > 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]<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] For more options: http://groups.google.com/group/farcry-dev -------------------------------- Follow us on Twitter: http://twitter.com/farcry
