https://community.databricks.com/t5/get-started-discussions/constraint-options-usage/m-p/55107#M1963 <P>I am trying to use the <A href="https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-create-table-constraint.html" target="_self">constraints options:</A></P><UL><LI>NOT ENFORCED</LI><LI>DEFERRABLE</LI><LI>INITIALLY DEFERRED</LI><LI>NORELY</LI></UL><P>However it seems I am not able to use them successfully.&nbsp;</P><P>When I try to use them with PRIMARY KEYS (not sure if it is possible), I am not able to enforce any key.</P><P>And it also seems I cannot use them with other constraints:</P><P>How are we supposed to use this constraint option? Thank you</P><DIV><DIV class="">&nbsp;</DIV></DIV> Tue, 12 Dec 2023 05:39:32 GMT Xyrion 2023-12-12T05:39:32Z https://community.databricks.com/t5/get-started-discussions/constraint-options-usage/m-p/55107#M1963 <P>I am trying to use the <A href="https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-create-table-constraint.html" target="_self">constraints options:</A></P><UL><LI>NOT ENFORCED</LI><LI>DEFERRABLE</LI><LI>INITIALLY DEFERRED</LI><LI>NORELY</LI></UL><P>However it seems I am not able to use them successfully.&nbsp;</P><P>When I try to use them with PRIMARY KEYS (not sure if it is possible), I am not able to enforce any key.</P><P>And it also seems I cannot use them with other constraints:</P><P>How are we supposed to use this constraint option? Thank you</P><DIV><DIV class="">&nbsp;</DIV></DIV> Tue, 12 Dec 2023 05:39:32 GMT https://community.databricks.com/t5/get-started-discussions/constraint-options-usage/m-p/55107#M1963 Xyrion 2023-12-12T05:39:32Z https://community.databricks.com/t5/get-started-discussions/constraint-options-usage/m-p/55110#M1964 <P>BTW the forum is bugged I can't paste code..</P> Tue, 12 Dec 2023 05:40:29 GMT https://community.databricks.com/t5/get-started-discussions/constraint-options-usage/m-p/55110#M1964 Xyrion 2023-12-12T05:40:29Z