Rules
Go Up to Supported Objects
Rules promote data integrity by allowing you to validate the values supplied to a table column. They are reusable objects that you can bind to table columns or user datatypes. For example, you can create a rule, bind it to a column in a table and have it specify acceptable values that can be inserted into that column.
Creating and editing
- Rules Wizard (PostgreSQL) and Rules Editor (PostgreSQL)
- Rules Wizard (SQL Server) and Rules Editor (SQL Server)
- Rules Wizard (Sybase ASE) and Rules Editor (Sybase ASE)
DBMS platform availability and object actions/operations supported
The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.
| Object Action | PSTGRS * | SQL SVR | SYB ASE |
|---|---|---|---|
|
✓ |
|||
|
✓ |
✓ |
✓ | |
|
✓ |
✓ |
✓ | |
|
✓ | |||
|
✓ |
✓ | ||
|
✓ |
✓ | ||
|
✓ |
|||
|
✓ |
✓ |