I'm a newbi to SchemaSpy. With SchemaSpy 6x I have not been able to get check constraints to show up. SchemaSpy 5x would show these. I've tried mix/match various mssql...properties and mssql property section contents...etc. but cannot seem to get these showing. Using -cronprops I'm confident its picking up my specified .properties file. Can someone help point ment in the right direction?
SELECT TABLE_NAME,
COLUMN_NAME,
CHECK_CLAUSE,
cc.CONSTRAINT_SCHEMA,
cc.CONSTRAINT_NAME
FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc
INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE c
ON cc.CONSTRAINT_NAME = c.CONSTRAINT_NAME
ORDER BY CONSTRAINT_SCHEMA,
TABLE_NAME,
COLUMN_NAME
I would expect these to show up under the contraint tab in the check constraint section
Last edit: Ken Fugate 2018-04-26
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm a newbi to SchemaSpy. With SchemaSpy 6x I have not been able to get check constraints to show up. SchemaSpy 5x would show these. I've tried mix/match various mssql...properties and mssql property section contents...etc. but cannot seem to get these showing. Using -cronprops I'm confident its picking up my specified .properties file. Can someone help point ment in the right direction?
SELECT TABLE_NAME,
COLUMN_NAME,
CHECK_CLAUSE,
cc.CONSTRAINT_SCHEMA,
cc.CONSTRAINT_NAME
FROM INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc
INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE c
ON cc.CONSTRAINT_NAME = c.CONSTRAINT_NAME
ORDER BY CONSTRAINT_SCHEMA,
TABLE_NAME,
COLUMN_NAME
I would expect these to show up under the contraint tab in the check constraint section
Last edit: Ken Fugate 2018-04-26