Re: Problem renaming table

2003-08-14 Thread Tim Johnson
* Egor Egorov <[EMAIL PROTECTED]> [030814 03:49]: > Tim Johnson <[EMAIL PROTECTED]> wrote: > >I would like to rename a table if it exists. > > > > The following query > > IF EXISTS ALTER TABLE gwcc_members RENAME gwcc_members_bak; > > fails. > > > > also > > > > ALTER TABLE IF EXISTS gwcc_m

Re: Problem renaming table

2003-08-14 Thread Egor Egorov
Tim Johnson <[EMAIL PROTECTED]> wrote: >I would like to rename a table if it exists. > > The following query > IF EXISTS ALTER TABLE gwcc_members RENAME gwcc_members_bak; > fails. > > also > > ALTER TABLE IF EXISTS gwcc_members RENAME gwcc_members_bak; > fails. > > > 1)What is the correct

Re: Problem renaming table

2003-08-14 Thread Roger Baklund
* Tim Johnson [...] > > >I would like to rename a table if it exists. > > > > > > The following query > > > IF EXISTS ALTER TABLE gwcc_members RENAME gwcc_members_bak; > > > fails. > > > > > > also > > > > > > ALTER TABLE IF EXISTS gwcc_members RENAME gwcc_members_bak; > > > fails. > > > > > >

Problem renaming table

2003-08-14 Thread Tim Johnson
Hello All: I would like to rename a table if it exists. The following query IF EXISTS ALTER TABLE gwcc_members RENAME gwcc_members_bak; fails. also ALTER TABLE IF EXISTS gwcc_members RENAME gwcc_members_bak; fails. 1)What is the correct syntax? 2)Where is documentation. I'm using ver. 3.2