> ## Documentation Index
> Fetch the complete documentation index at: https://docs.tablepro.app/llms.txt
> Use this file to discover all available pages before exploring further.
# Change Tracking
> Queue cell edits, row inserts, and deletions locally before committing to the database
# Change Tracking
Changes in TablePro are queued in memory, not applied immediately. Edit cells, insert rows, delete rows, then review everything before committing. Nothing touches the database until you say so.
Change tracking is per-tab. Switching tabs preserves your edits.
## Data Changes
TablePro tracks three types of data changes: cell edits, row insertions, and row deletions.
### Editing Cells
Double-click any cell to edit (see [Data Grid](/features/data-grid)). Changes queue immediately.
Changing a value back to its original automatically removes it from the queue.
### Adding Rows
To insert a new row:
1. Click the **+** button in the toolbar or use the keyboard shortcut
2. A new row appears at the bottom of the data grid, marked with an insertion indicator
3. Fill in the values for each column
4. Columns with default values are pre-filled with `DEFAULT`
Edits to cells in a new row are folded into the insertion, not tracked as separate updates.
### Deleting Rows
Select rows and press `Delete`. Deleted rows show a strikethrough indicator and stay visible until commit or discard.
Batch deletion of multiple rows is tracked as a single undo action. Undoing a batch deletion restores all rows at once.
## Commit & Discard
### Committing Changes
Click **Commit** or press `Cmd+S`. TablePro generates parameterized SQL, executes it, clears the queue, and refreshes the grid.
Generated SQL:
| Change Type | SQL Generated |
| ------------- | ---------------------------------------- |
| Cell edit | `UPDATE ... SET column = ? WHERE pk = ?` |
| Row insertion | `INSERT INTO ... (columns) VALUES (?)` |
| Row deletion | `DELETE FROM ... WHERE pk = ?` |
UPDATE statements require a primary key on the table. If no primary key is defined, TablePro shows an error when you try to commit updates. DELETE statements can work without a primary key by matching all column values.
### Discarding Changes
Click **Discard** to revert all pending changes and clear the undo/redo stack.
### Previewing Data SQL
Click the **Preview SQL** button (eye icon) or press `Cmd+Shift+P` to see the exact SQL before committing. Use **Copy All** to copy to clipboard.
The preview inlines parameter values so you can verify exactly what will run. Destructive operations are highlighted with a warning banner.
## Undo & Redo
| Action | Shortcut |
| ------ | ------------- |
| Undo | `Cmd+Z` |
| Redo | `Cmd+Shift+Z` |
Context-aware: `Cmd+Z` undoes text edits when the SQL editor is focused, data changes when the grid is focused.
Stacks are per-tab. Committing or discarding clears both stacks.
## Schema Changes
Table structure changes (columns, indexes, foreign keys) use the same queue-based approach.
### Tracked Schema Operations
| Operation | What Is Tracked |
| ---------------------- | ----------------------------------------------------------- |
| **Add column** | New column definition (name, type, nullable, default, etc.) |
| **Modify column** | Old and new column definitions |
| **Delete column** | Column marked for removal |
| **Add index** | New index definition (name, columns, type, uniqueness) |
| **Modify index** | Old and new index definitions |
| **Delete index** | Index marked for removal |
| **Add foreign key** | New FK definition (columns, references, actions) |
| **Modify foreign key** | Old and new FK definitions |
| **Delete foreign key** | FK marked for removal |
| **Modify primary key** | Old and new primary key columns |
### Visual Indicators
* **New items**: highlighted with an insertion color
* **Modified items**: changed fields are marked
* **Deleted items**: shown with a deletion indicator
## Previewing Schema SQL
Before applying schema changes, preview the generated SQL:
Make your changes in the Structure tab, then click **Commit** (`Cmd+S`). A preview sheet shows the ALTER TABLE statements. Click **Apply Changes** to execute or **Cancel** to go back.
Copy individual SQL statements from the preview sheet using the copy button next to each statement.
## SQL Generation
Data changes use parameterized statements. Schema changes produce database-specific ALTER TABLE statements:
```sql theme={null}
UPDATE `users` SET `name` = ? WHERE `id` = ? LIMIT 1
INSERT INTO `users` (`name`, `email`) VALUES (?, ?)
DELETE FROM `users` WHERE `id` = ? OR `id` = ?
ALTER TABLE `users` ADD COLUMN `phone` VARCHAR(20) NOT NULL
ALTER TABLE `users` MODIFY COLUMN `name` VARCHAR(200) NOT NULL
```
```sql theme={null}
UPDATE "users" SET "name" = $1 WHERE "id" = $2
INSERT INTO "users" ("name", "email") VALUES ($1, $2)
DELETE FROM "users" WHERE "id" = $1 OR "id" = $2
ALTER TABLE "users" ADD COLUMN "phone" VARCHAR(20) NOT NULL
ALTER TABLE "users" ALTER COLUMN "name" TYPE VARCHAR(200)
```
```sql theme={null}
UPDATE "users" SET "name" = ? WHERE "id" = ?
INSERT INTO "users" ("name", "email") VALUES (?, ?)
DELETE FROM "users" WHERE "id" = ?
ALTER TABLE "users" ADD COLUMN "phone" TEXT
CREATE INDEX "idx_email" ON "users" ("email")
```
SQLite has limited ALTER TABLE support. Use the SQL editor for modifications that require table recreation.