DrewDog_21
Jan 6th, 2000, 03:20 AM
I have create this querydef to add a table:
Set qdf.SQL = "ALTER TABLE Employees ADD COLUMN Department Text"
qdf.Execute
I don't want to add the column as the very last column. I thought that the correct syntax was something like
Set qdf.SQL = "ALTER TABLE Employees ADD COLUMN Department Text BEFORE Birthdate"
to add the column "Department" before the column "Birthdate" but that doesn't work. can someone remind me of the correct syntax? I know it is possible I just can't remember or find in my SQL books.
Thanks
Andrew
Set qdf.SQL = "ALTER TABLE Employees ADD COLUMN Department Text"
qdf.Execute
I don't want to add the column as the very last column. I thought that the correct syntax was something like
Set qdf.SQL = "ALTER TABLE Employees ADD COLUMN Department Text BEFORE Birthdate"
to add the column "Department" before the column "Birthdate" but that doesn't work. can someone remind me of the correct syntax? I know it is possible I just can't remember or find in my SQL books.
Thanks
Andrew