Can a Quickbase Table be Dropped through QUNECT?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
We have a linked server using QUNECT on SQL Server. We are using the QB tables in various stored procedures where the table names are assigned to variables. I know we can delete data from the QB tables, which kind've scares me because if we accidentally use the wrong variable in a delete statement, one that is assigned to a Quickbase table, all our data will be deleted.

So, my thought is to use a Drop statement instead where the table will be deleted all together because I'm assuming that a drop statement will not work on a QB table through QUNECT, so it will just throw us an error in the event we make a mistake. Am I assuming correctly? I just want to make sure before I modify the stored procedures.
Photo of Dan

Dan

  • 30 Points

Posted 1 year ago

  • 0
  • 1
Photo of Drew

Drew

  • 432 Points 250 badge 2x thumb
I believe that drop is a supported syntax with Qunect and will in fact drop your table.  I would test it. . . . . 
Photo of Dan

Dan

  • 30 Points
Really? I was hoping that it would not. All it takes is referencing the wrong variable and that can wipe everything out.
Photo of Drew

Drew

  • 432 Points 250 badge 2x thumb
The other thing you can probably look at is the user permissions of the role that you are using to execute QUNECT with.  My guess is you are probably using administrators credentials.  You should be able to use credentials from a quickbase user that only allows adding / modifying records etc.  Again, I would test.