> ## Documentation Index
> Fetch the complete documentation index at: https://docs.standardcomputers.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Records: Querying and Managing Rows in Standard R1

> Understand what Records are in Standard R1, how to access Standard tables, create records, count them, and purge all rows from a table.

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:

```text theme={null}
[vehicles] + ("VIN173", "Dodge", "Durango", "Red")
```

## Counting Records

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

```text theme={null}
count [vehicles]
```

## Purging Records

To empty a Standard table and remove all of its records, prepend the table declaration with `purge`:

```text theme={null}
purge [vehicles]
```

<Warning>
  `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.
</Warning>