Check Constraint Generator

The Check Constraint (auto assigned) Generator generates values within the value range of the check constraint expression. The generator is automatically assigned to a column for which a certain check constraint is defined. It uses the check constraint expression to limit the value range of the data generated for the column.

The dialog box of the Check Constraint shows the check constraint expression and contains Basic Settings and custom settings. You can customize the generator by changing the basic and custom settings.

Custom Settings

Check constraint:

Specifies the name of the check constraint for the selected column.

Expression

Specifies the check constraint expression.

Use Min and Max range from…generator

Select the check box to set minimum and maximum values of the specified generator (next by relevance). This option is available only for Numeric and Date/Time data types.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for SQL Server?