Populate tables with constraints

Last modified: October 8, 2024

dbForge Data Generator for SQL Server generates valid values for tables with simple check constraints. However, the tool can not generate data for tables with composite check constraints. In these cases, the following message will be displayed:

This type of check constraints is not supported.

The following example illustrates a table with a simple and composite check constraints:

CREATE TABLE dbo.CHECKconstraint (
ID int NOT NULL,
simple_check int NULL,
composite_check nvarchar(1) NULL,
CHECK ([composite_check]<>'a' AND [composite_check]<>'b'),
CHECK ([simple_check]>(2))
)
ON [PRIMARY]
GO

The dbForge Team is working on this issue and the number of supported check constraint constructs will be extended.