View Issue Details

IDProjectCategoryView StatusLast Update
0004927SymmetricDSNew Featurepublic2023-02-01 15:43
Reporterpmarzullo Assigned To 
Prioritynormal 
Status newResolutionopen 
Product Version3.12.7 
Summary0004927: Send CHECK constraints as part of DDL schema when sending to target node
DescriptionExample:

CREATE TABLE table1
    (ID INT IDENTITY(1,1) NOT NULL,
     Name VARCHAR(100) NOT NULL,
     BirthDate Date NULL,
     CONSTRAINT CK_TEST_BirthDate CHECK (BirthdAte > '1950-01-01')
)
GO

INSERT INTO table1 (Name, Birthdate)
VALUES ('TEST','1901-01-01')

This insert should fail since the date is outside of the allowed dates.

Many database types support CHECK constraints:
Oracle
SQL Server
MySQL 8.0.16
MariaDB
SQLite
PostgreSQL
DB2
and others I am sure.

Probably should consider holding off sending check constraints just like indexes and foreign keys when sending schema as part of an initial load.
Should also consider being able to add the ability to not send check constraints when sending schema using symadmin.
Tagsddl/schema

Activities

brenttempleton

2023-02-01 15:43

reporter   ~0002255

This would be a feature I would also like.
- Brent @ Select Sires Inc

Issue History

Date Modified Username Field Change
2021-03-28 15:48 pmarzullo New Issue
2021-03-28 15:48 pmarzullo Tag Attached: ddl/schema
2023-02-01 15:43 brenttempleton Note Added: 0002255