validate_data_integrity
Run integrity checks on a SQL Server table, detecting foreign key violations, duplicate records, and null violations.
Instructions
Validate data integrity for a table (FK violations, duplicates, null violations)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema name (default: dbo) | |
| checkFK | No | Check foreign key violations (default: true) | |
| tableName | Yes | Name of the table | |
| checkNulls | No | Check null violations (default: true) | |
| checkDuplicates | No | Check duplicate records (default: true) |