Delete a column that its name is First 1

[Bitaoo]

Hello,

I have a problem, I defined a column named First in my table by mistake and now I cannot delete this column, I think First is a reserved word in MSAccess DB, would you please help me to drop this column from Table, Here the statement that I am using:

Alter Table ChartChoices Drop Column First

Thanks,
--Bita

 

[PHV]

Why not drop the column in table design view ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Bitaoo]

I need to do it through a VB6 program. Thanks

 

[RoyVidar]

Sometimes, when dealing with reserwed words, one might get lucky surrounding them with [brackets].

[tt]Alter Table ChartChoices Drop Column [First][/tt]

Roy-Vidar

 

[Bitaoo]

Thanks a lot Roy. That was great.
--Bita