RaiseErrorSubsetConstraintViolated Procedure (Repository Schema)

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

Raises an error when a subset constraint is violated. A subset constraint specifies that the values in one column must be a subset of those in another column.

[Repository].[RaiseErrorSubsetConstraintViolated] ( @subsetSchema, @subsetTable, @subsetColumn, @subsetColumnIsNullable, @supersetSchema, @supersetTable, @supersetColumn )

Arguments

@subsetSchema

Type: sysname. The name of the schema that is associated with the subset column.

@subsetTable

Type: sysname. The name of the table that contains the subset column.

@subsetColumn

Type: sysname. The column name that is constrained to hold a subset of values from the superset column.

@subsetColumnIsNullable

Type: bit. A bit flag that indicates whether a null value is valid in the subset column.

@supersetSchema

Type: sysname. The name of the schema that is associated with the superset column.

@supersetTable

Type: sysname. The name of the table that contains the subset column.

@supersetColumn

Type: sysname. The name of the superset column. This is the source column for possible values in the subset column.

Remarks

See Also

Reference

Repository Procedures
Repository Schema

Send comments about this topic to Microsoft.