RaiseErrorSubsetConstraintViolated2 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. Unlike the [Repository].[RaiseErrorSubsetConstraintViolated] procedure, this procedure is used for subset constraints that involve multiple columns.
[Repository].[RaiseErrorSubsetConstraintViolated2] ( @subsetSchema, @subsetTable, @subsetColumns, @subsetColumnIsNullable, @supersetSchema, @supersetTable, @supersetColumns )
Arguments
@subsetSchema
Type: sysname. The name of the schema that is associated with the subset columns.
@subsetTable
Type: sysname. The name of the table that contains the subset columns.
@subsetColumns
Type: nvarchar(max). A list of column names that are constrained to hold a subset of values from the superset columns.
@subsetColumnIsNullable
Type: bit. A bit flag that indicates whether a null value is valid in the subset columns.
@supersetSchema
Type: sysname. The name of the schema that is associated with the superset columns.
@supersetTable
Type: sysname. The name of the table that contains the subset columns.
@supersetColumns
Type: nvarchar(max). The name of the superset columns. These are the source columns for possible values in the subset columns.