Skip to main content
Records are rows in a table created using the values provided for constraints. Like other databases, there are many ways you can interact with records or perform queries.

​
Accessing Tables

Records and tables can be accessed by starting a query with a Standard’s name or reference in brackets, followed by the command. The example below adds a new record to the vehicles table:

​
Counting Records

Count records in a Standard table by prepending a record query with count:

​
Purging Records

To empty a Standard table and remove all of its records, prepend the table declaration with purge:
purge removes ALL records from a table and cannot be undone. Make sure you have a backup or export of your data before running this command.