Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Alter Table problem |
Wed, Oct 21 2009 12:59 PM | Permanent Link |
Michael Fullerton | EDB 2.02
Why will this combined statement not work: ALTER TABLE "MyTable" ALTER COLUMN ID AS INTEGER DROP CONSTRAINT "PrimaryKey" but these two separate statements will: ALTER TABLE "MyTable" ALTER COLUMN ID AS INTEGER ALTER TABLE "MyTable" DROP CONSTRAINT "PrimaryKey" According to the help file you should be able to combine several actions into one line. |
Wed, Oct 21 2009 2:02 PM | Permanent Link |
Uli Becker | Michael,
> ALTER TABLE "MyTable" ALTER COLUMN ID AS INTEGER DROP CONSTRAINT > "PrimaryKey" Just add a comma after AS INTEGER and it should work (untested). Regards Uli |
Wed, Oct 21 2009 2:19 PM | Permanent Link |
Michael Fullerton | On Wed, 21 Oct 2009 20:02:06 +0200, Uli Becker
<johnmuller54@googlemail.com> wrote: >Michael, > >> ALTER TABLE "MyTable" ALTER COLUMN ID AS INTEGER DROP CONSTRAINT >> "PrimaryKey" > >Just add a comma after AS INTEGER and it should work (untested). Right thanks Uli, I now see the [,ADD|ALTER|DROP] line in the help. It makes sense now but would be clearer using [,] or even an example with multiple actions. |
This web page was last updated on Sunday, May 5, 2024 at 10:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |