The actual properties of a column check constraint vary with the target DBMS. The Column check constraint tab gives you a general idea.
Check constraint name
The name of the check constraint. If this property is left blank, the target DBMS may assign a name.
Not for replication
The NOT FOR REPLICATION option is used by SQL Server replication to implement ranges of identity values in a partitioned environment. When the option is set, SQL Server maintains the original identity values on rows added by the replication agent, but continues to increment the identity value on rows added by other users. When a user adds a new row to the table, the identity value is incremented in the normal way. When a replication agent replicates that row to a Subscriber, the identity value is not changed when the row is inserted in the Subscriber table.
Constraint check
The text of the constraint. SA allows Check constraint as part of the text.
Default constraint name
The name of the default constraint. The default value is defined on the Column general properties. If this property is left blank, the target DBMS may assign a name.
Unique constraint name
The name of the unique constraint. The unique value is defined on the Column general properties. If this property is left blank, the target DBMS may assign a name.