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.

What is R in your case ? I dont understand your question. Can you explained bit ? — , Sep 24 '14 at 06:58
@ajay, Try to hover with your mouse above the `r` tag and find out — David Arenburg, Sep 24 '14 at 07:03
R language, A software I use is called Rstudio, is there a way to delete the rownames column which is in SQLDatabase — xavier, Sep 24 '14 at 07:04
@mgriebe library(RODBC) ch <- odbcConnect("vertica", uid="dbadmin", pwd="123" ) — xavier, Sep 24 '14 at 07:20

score 0 · Accepted Answer · answered Sep 24 '14 at 07:33

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

How to delete 1st column in SQL Database using R

1 Answers1