Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 3 of 3 total

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.