ALTER statement for a table w/ a space in the name???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anybody know how to format an ALTER statement for a table that has a
space in the name? Before you flame me, no I did not design the table. :-) I
need to change the length of a single field in the table, but the ADO keeps
barfing on the ALTER statement. Here are the various ways that I've tried it:

ALTER TABLE [Split Definition] ALTER COLUMN Number TEXT(4);

ALTER TABLE Split Definition ALTER COLUMN Number TEXT(4);

ALTER TABLE "Split Definition" ALTER COLUMN Number TEXT(4);

Thanks
Eric
 
Never mind. I figured it out. Duh.

ALTER TABLE [Split Definition] ALTER COLUMN [Number] TEXT(4);
 
Back
Top