Delete all rows from a table
Delete all rows from the specified table.
labkey.truncateTable(baseUrl = NULL, folderPath, schemaName, queryName)
baseUrl |
a string specifying the |
folderPath |
a string specifying the |
schemaName |
a string specifying the name of the schema of the domain |
queryName |
a string specifying the query name |
Deletes all rows in the table in a single transaction and will also log a single audit event for the action. Not all tables support truncation, if a particular table doesn't support the action, an error will be returned. The current list of tables supporting truncation include : lists, datasets, issues, sample sets, data classes.
Returns the count of the number of rows deleted.
Karl Lum
## create a data frame and infer it's fields
library(Rlabkey)
labkey.truncateTable(baseUrl="http://labkey/", folderPath="home",
schemaName="lists", queryName="people")Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.