
Answer-first summary for fast verification
Answer: NOT NULL, CHECK
Databricks supports standard SQL constraint management clauses, which are divided into two categories: enforced and informational. Enforced constraints automatically verify the quality and integrity of data added to a table. The two supported types are: 1. **NOT NULL**: Ensures that specific columns cannot contain null values. 2. **CHECK**: Requires that a specified boolean expression must be true for each input row. These constraints are crucial for maintaining data integrity and are only supported with Delta Lake. Violations of these constraints result in transaction failures.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.