Forum Discussion

DanDan2's avatar
DanDan2
Qrew Trainee
8 years ago

Can a Quickbase Table be Dropped through QUNECT?

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.
  • DrewVoge's avatar
    DrewVoge
    Qrew Cadet
    8 years ago
    I believe that drop is a supported syntax with Qunect and will in fact drop your table.  I would test it. . . . . 
  • DanDan2's avatar
    DanDan2
    Qrew Trainee
    8 years ago
    Really? I was hoping that it would not. All it takes is referencing the wrong variable and that can wipe everything out.
  • DrewVoge's avatar
    DrewVoge
    Qrew Cadet
    8 years ago
    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.