sqlrrodbcvsql

How to delete 1st column in SQL Database using R

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.

Solution

  • 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")