How to delete 1st column in SQL Database using R

Question

This is a simple example
Basket                                        

rownames fruit       quantities     
1        apple           3
2        orange          4
3        tomatoes        6
4        watermelon      7
5        durian          8

How do I remove the rownames using R in SQL, sorry I am new to R and SQL.

Answer 1

Note that I cannot test this on my machine.

You can try setting rownames=FALSE when you sqlFetch the table. That may solve your problem.

But, to solve the problem in the title, you can do:

BasketDF<-sqlFetch(ch,"Basket")
NewBasket<-BasketDF[,-1]
sqlUpdate(ch,NewBasket,"Basket")