Thanks. Keith Chisarik
My post was just text, and I tried it a few times. Anyone else having issues?
You had some formatting that wasn't supported. If you paste the text into NotePad or something the copy it from there it will strip the formatting and you will be able to paste it without being scolded
No. The DDT does support contraints. They are created for you when you create a relationship or setup a default value.
Obviously you can call script like you have done to do this for you. But the DDT will create all of the contraints for you if you setup your relationships. Also, when you assign a default value to a field, a constraint will be created as well.
Here is my question in the meantime
Am I correct that DDT does not support constraints currently?
I accomplished what I wanted by checking for the constraint in INFORMATION_SCHEMA.TABLE_CONSTRAINTS and adding it (if needed) via a post-build script in the DDT 'Profile Scripts', I guess I am just making sure that this is the way to do this if one wants to make sure everything needed to recreate a given database is in the DDT metadata.
Is there a constraint tab/node/checkbox I am missing somewhere or is the above the way to currently maintain constraints? Keith Chisarik
My post was just text, and I tried it a few times. Anyone else having issues? Keith Chisarik