---
title: SAIF.Framework.Preferences SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: <owner>
last_reviewed: 2026-07-23
library: SAIF.Framework.Preferences
reference_type: package
---

# SAIF.Framework.Preferences SQL catalog

This page indexes all 7 SQL statements in `SAIF.Framework.Preferences`, all issued inline by `PreferenceData` against a single table, `USER_PREFERENCE`.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-004](SQL-004-insert-preference.md) | Insert a new preference row | Inline | USER_PREFERENCE | `PreferenceData` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-002](SQL-002-get-preferences.md) | Retrieve a single preference blob scoped by app/user/page | Inline | USER_PREFERENCE | `PreferenceData` |
| [SQL-003](SQL-003-get-preferences-for-user.md) | Retrieve all preference rows for a user | Inline | USER_PREFERENCE | `PreferenceData` |
| [SQL-007](SQL-007-does-pref-exist.md) | Scalar existence check (`Count(*)`) before insert/update | Inline | USER_PREFERENCE | `PreferenceData` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-005](SQL-005-update-preference.md) | Update an existing preference row's text and audit columns | Inline | USER_PREFERENCE | `PreferenceData` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-006](SQL-006-delete-preference.md) | Delete a preference row when the supplied text is empty | Inline | USER_PREFERENCE | `PreferenceData` |

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-insert-preference-sequence.md) | Inline `USER_PREFERENCE_SEQ.nextval` key-generation expression embedded in the SQL-004 INSERT | `USER_PREFERENCE_SEQ` | USER_PREFERENCE | `PreferenceData` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)

## Sources
- SAIF.Framework.Preferences\PreferenceData.cs